Database Systems


Recommended prerequisite for participation in the module

The module builds on knowledge gained in the module Algorithms and Data Structures

Content, progress and pedagogy of the module

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


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


  • 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


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

The teaching is organized in accordance with the general teaching methods for the education § 17.

Extent and expected workload

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



Name of examDatabase Systems
Type of exam
Written or oral exam
Assessment7-point grading scale
Type of gradingInternal examination
Criteria of assessmentThe criteria of assessment are stated in the Examination Policies and Procedures

Additional information

Kontakt: Studienævn for datalogi via eller 9940 8854

Facts about the module

Danish titleDatabasesystemer
Module codeDSNSWCB514
Module typeCourse
Duration1 semester
Language of instructionDanish
Empty-place SchemeYes
Location of the lectureCampus Copenhagen
Responsible for the module


Education ownerBachelor of Science (BSc) in Engineering (Software)
Study BoardStudy Board of Computer Science
DepartmentDepartment of Computer Science
FacultyThe Technical Faculty of IT and Design