Print
Code
IT-DBS1
Version
5.0
Offered by
ICT Engineering
ECTS
5
Prerequisites
Completed the 1st semester Software Engineering course "Programming 1" (previously “Software Development with Java 1”) 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%)
2. Course assignments handed in before deadline.
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:
The students must import a database and dataset before the exam. The first part of the exam will ask questions about this dataset. This dataset will be made available through WISEflow several days before the exam.
Digital written exam (2 parts), 4 hours:
Part 1: Multiple choice and written answers in WISEflow
Part 2: Design and implementation
External assessment
Tools allowed:
All aids are allowed included access to online material. However, it is not allowed to use AI tools such as ChatGPT and similar AI and Machine Learning driven tools and chatbots.
Re-exam:
Conducted as the ordinary exam.
Grading criteria
Grading based on the Danish 7-point scale.
Additional information
Responsible
Ole Ildsgaard Hougaard (oih)
Valid from
8/1/2023 12:00:00 AM
Course type
Keywords
Data modelling, E/R diagrams, Relational database systems, Tables and constraints, Views, Triggers, Indexes, Transactions