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.
The course is concerned with base principles and important aspects of
relational databases. Among others, we treat:
- ER and UML class diagrams (for the design and evaluation of database
- the relational database model,
- functional dependencies,
- integrity constraints,
- transactions and concurrency control.
Form of tuition
Lectures, exercise/practicum classes, individual homework and practicum
Type of assessment
The practicum is mandatory for qualifying for the exam.
Database Systems, The Complete Book, by: Hector Garcia-Molina & Jeffrey
D. Ullman & Jennifer Widom. 2nd edition.
Recommended background knowledge
Basic programming skills help.
2CS, 2IMM, 2LI, 2BA