Print
Code
IT-DBS1
Version
6.0
Offered by
ICT Engineering
ECTS
5
Prerequisites
Completed the 1st semester Software Engineering course PRO1 (formerly SDJ1) or a similar course.
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).
Knowledge
Having completed this course, students will be able to:
• account for the relationship between relational algebra and SQL
• define the relational model
• distinguish the 3 normal forms
• classify keys in relational databases
• explain indexes
Skills
Having completed this course, students will be able to:
• use relational modelling to model business cases
• use UML to document ER-Models
• 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 to combine data
• use transactions to prevent data corruption
• create triggers
• create views
Competences
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
Topics
Teaching methods and study activities
The semester has 48 classroom lessons. These lessons will consist of teacher presentations and exercises.
The course will include one or more course assignment(s).
Resources
• Connolly, Thomas and Begg, Carolyn: Database Systems (5th edition). Harlow, 2010, Pearson Education. ISBN: 987-0-321-52306-8.
• Supplementary notes.
Evaluation
Examination
Exam prerequisites:
1. Attendance (≥ 75%)
If the exam prerequisites are not met, the student must complete a written assignment in WISEflow to qualify for the re-exam.
This assignment will be scheduled after the ordinary exam.
Type of exam:
During the semester, students must prepare six small assignments within the syllabus.
At the exam, the student draws one of the known assignments.
The examination is based on the student's answer and develops into an examiniation in the rest of the course's syllabus.
The assessment is based solely on the student's oral performance.
External assessment
Tools allowed:
None
Re-exam:
Conducted as the ordinary exam.
Grading criteria
Grading based on the Danish 7-point scale.
Additional information
Responsible
Allan Henriksen (alhe)
Valid from
8/1/2025 12:00 AM
Course type
Business and Management<br/>
Keywords
Data modelling, E/R diagrams, Relational database systems, Tables and constraints, Views, Triggers, Indexes, Transactions