Course Objective

The course objective is to obtain a good knowledge and understanding of
relational database systems.
This includes the ability to develop conceptual database models, as well
as key concepts and skills in
relational database theory and practice.

Course Content

The course is concerned with base principles and important aspects of
relational databases.

Among others, we treat:
- ER diagrams (for the design and evaluation of database schemata),
- the relational database model,
- functional dependencies and database normalization,
- integrity constraints,
- transactions and concurrency control.

Teaching Methods

Lectures, exercise/practicum classes and individual homework.

Method of Assessment

The homework is mandatory for qualifying for the exam (70% of the
homework points to qualify for the exam). In case at least 90% of the
homework points is obtained, 0.5 bonus point is awarded for the final
grade.
At the end of the course there is a final exam. The overall grade is the
grade of the final exam plus the possibly 0.5 bonus point obtained for
the homework. (The bonus is only added for students that pass the exam
with a grade of at least 5.5.)

There is no resit opportunity for the homework.

Literature

Database Systems, The Complete Book, by: Hector Garcia-Molina & Jeffrey
D. Ullman & Jennifer Widom. 2nd edition.

Target Audience

2CS, 2IMM, 2LI, 2BA

Recommended background knowledge

Basic programming skills help.