IBE211 Databases (Spring 2026)

The course introduces students to the fundamentals of database systems. This course covers five major parts such as (1) SQL and relational databases; (2) database design; (3) database administration and maintenance; (4) database applications; and (5) NoSQL database alternatives.

1. SQL and relational databases: In a relational database, data is organized in tables. Here, we will use SQL to define tables, insert, change and delete data as well as retrieve data with selection queries.

2. Database design: To develop a new database, we will have to first create a model. Data modeling with ER (Entity Relationship) provides a kind of architect's drawing of the database. Normalization is used to ensure that the model provides a good table structure without double storage. Physical organization with indexes is important to ensure fast response time.

3. Database administration: A database can have many simultaneous users and is in production for a long time. It is explained which mechanisms a database system has to handle error situations and multiple simultaneous users, as well as tasks a database administrator performs to ensure stable and efficient operation of the system.

4. Database applications: End users usually work with a system via specially developed applications (programs). The subject of this section is the development of web applications, REST APIs, and the use of stored routines and triggers on the database server.

5. We will look at XML and JSON as storage and transfer formats for semi-structured data, and then at NoSQL databases and object-relational databases.

After completing the course, the student will have achieved the following learning outcomes:

Knowledge

The candidate:

• has knowledge of the technical principles behind the construction and functioning of databases.
• understands how databases integrate into and support broader information systems.
• has an overview of key phases in the database development lifecycle, including design, implementation, and maintenance.
• has knowledge of performance considerations and operational tasks related to database systems.

Skills

The candidate:

• can design basic data models using the Entity-Relationship (ER) method.
• can apply normalization techniques to improve data structure and integrity.
• can implement, query, and manage relational databases using SQL.
• can assess and address simple performance and operational issues in database systems.

General Competence

The candidate:

• can contribute to the planning and execution of smaller development projects involving data storage and retrieval.
• can participate in routine operational tasks related to database systems.
• demonstrates an understanding of ethical and legal considerations related to data management and storage.

This course is structured for flexible participation, primarily online, with no scheduled lectures. All instruction, materials, and exercise reviews are provided digitally via Canvas and Microsoft Teams, including access to recorded lectures and demonstrations.

Three webinars will be held during the semester, covering startup guidance, review of exercises/assignments, and exam preparations/Q&A. These will be added to the students' schedules and posted as recordings.

Exercises must be completed on the student's own computer.

Three work requirements are mandatory and must be submitted by the stated deadlines to qualify for the final exam.

The course will be taught in English.

• Mandatory coursework requirement: Assignment(s)
• Number of coursework requirements: 3
• Required coursework submissions: 3

• Form of assessment: Digital Home Exam
• Proportion: 100%
• Duration: 4 hours
• Grouping: Individual
• Grading scale: Letter (A - F)
• Supported material: All printed and written supporting material