Recommended prerequisite for participation in the module

Content, progress and pedagogy of the module

Disclaimer.
This is an English translation of the module. In case of discrepancy between the translation and the Danish version, the Danish version of the module is valid.

Learning objectives

Knowledge

The student must gain insight into the following topics in database systems:

• the relational model and relational algebra entity relationship charts (ERD)
• Structured Query Language (SQL)
• logical design of relational databases (normal forms)
• physical database design
• query management and optimization
• transactions, concurrency control and recovery

A number of possible topics that can also be covered in the course depending on the teacher's and the students' abilities and background, for example:

• relational calculus
• parallel databases
• distributed databases
• triggers and stored procedures

Skills

• be able to explain the relational model and apply relational algebra to a data set
• be able to construct an ERD for smaller, concrete scenarios
• be able to create a relational database design that adheres to recognized normal forms
• be able to use SQL to create and query a database
• be able to explain an execution plan for an SQL query and assess whether the plan is effective
• be able to explain the concept of transaction and key topics within concurrency control and recovery

Competences

Using the fundamental concepts and theories that are common to most database systems, the student must be able to use these to handle larger data sets in practice.

Type of instruction

Extent and expected workload

The student is expected to spend 30 hours per ECTS, which for this activity means 150 hours.

Exam

Exams

Additional information