Database Systems (from S22)





Offered by

ICT Engineering




SDJ1 or similar

Main purpose

The main purpose of the course is two-fold. Firstly, students are to learn methods for designing, implementing and operating single-user relational databases. Secondly, students are to learn the main principles, architecture and technologies of a typical relational database management system (RDBMS).


Having completed this course, students will be able to:
• explain the relationship between relational algebra and SQL
• explain the relational model
• explain the 3 normal forms
• explain keys in relational databases
• explain joins
• explain transactions


Having completed this course, students will be able to
• create ER-Models with UML
• use Data Definition Language (DDL) to create databases
• use Data Modeling Language (DML) to manipulate data in a database
• use the mapping method to convert ER-Models to Relational Models
• use normalisation to normalise a database schema to 3rd normal form
• create SQL statements to create, replace, update and delete data in a database
• use keys in relational databases
• use joins


Having completed this course, students will be able to:
• Design and implement a database schema on the 3rd normal form
• Use a database in application development


Teaching methods and study activities

Lessons alternate between theory and practical exercises using the PostgreSQL relational DMBS. The course contains one or more compulsory assignments.
Expected workload for students is estimated to 135 hours.


Literature used:
• Connolly, Thomas and Begg, Carolyn: Database Systems (5th edition). Harlow, 2010, Pearson Education. ISBN: 987-0-321-52306-8.                       
• Supplementary notes.



Criteria to qualify for the exam:
  • Course assignments handed in before deadline
  • The student must have an attendance of at least 75% in order to qualify for the exam. Students who do not have at least 75% attendance will automatically fail the ordinary exam.

Duration: 4 hours
Digital written examination (2 parts):

Part 1: Multiple choice and written answers; 1 hour without aids
Part 2: Design and implementation; 3 hours with all aids, including internet connection

External assessment

Please note that re-examination may take a different form than the ordinary exam.

Grading criteria

Grading based on the Danish 7-point scale.
Examinations account for 100 % of final grade.

Additional information


Ole Ildsgaard Hougaard

Valid from

2/1/2022 12:00:00 AM

Course type

Compulsory Course for all ICT Engineering
2. semester


<div class="ExternalClassC9F4EA153FA74F0E903E11210D51BC37"><div>Data modelling, E/R diagrams, Relational database systems, Tables and constraints, Views, Triggers, Indexes, Transactions</div></div>