Credits: 5. Grading scale: TH. Optional for: D4, E4, F4, I4. Course coordinator: Per Holm, Inst f datavetenskap. Prerequisites: EDA025/EDA026/EDA027 Algorithms and Data Structures. Assessment: Written examination. The final grade is based on the examination and on the assignments. Homepage: http://www.cs.lth.se.

Aim
The aim is to give the students knowledge of

• general theory of database design

• theory of relational databases

• the query language SQL

• database systems in general

Contents
The course contains the following:

• Database systems in general

• Theory of object-oriented and entity/relationship design

• Relational databases, dependencies, normal forms, relational algebra

• The query language SQL

• Database systems, concurrency, security, integrity

Literature
Ullman J.D. and Widom J.: A First Course in Database Systems. Prentice Hall, 1997.