Print

Database Systems

Code

IT-DBS1

Version

1.3

Offered by

ICT Engineering

ECTS

5

Prerequisites

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).

Knowledge

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

Skills

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
  • implement simple mechanisms to deal with concurrency control
 

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

  • Data modelling
  • E/R diagrams
  • Relational database systems
  • Tables and constraints
  • Views
  • Triggers
  • Indexes
  • Transactions
 

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.
CATEGORY 1
Participation of lecturer and students
Initiated by the lecturer
55 hours-  40%
  • Lessons, scheduled
  • Exams and tests
CATEGORY 2
Participation of students
Initiated by the lecturer
50 hours - 37%
  • Assignments, self-study
  • Project and group work
  • Homework and preparation for exams
CATEGORY 3
Participation of students
Initiated by students
25 hours - 19 %
  • Homework and preparation for exams
  • Self-study
  • Study groups
CATEGORY 4
Participation of lecturer and students 
initiated by students
5 hours - 4 %
  • Project guidance

 

Resources

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

Evaluation

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.

 

Examination

‚ÄčOral Examination

The examination is held as a 20 minutes examination all inclusive. The student will be examined in a randomly picked topic from the course syllabus as well as one or more course assignments.

Internal Exam.

Grading criteria

Examinations account for 100 % of final grade.

Additional information

Responsible

Ole Ildsgaard Hougaard

Valid from

9/1/2019 12:00:00 AM

Course type

Compulsory Course for all ICT Engineering
2. semester

Keywords