TDDB48 Database Technology, 7,5 ECTS-points
/Databasteknik/

Advancement level:
C

Aim:
The course introduces practical and theoretical aspects of storage and retrieval of information in modern database managenments systems.

Prerequisites:
1) Basic course in programming 2) Basic course in data structures and algorithms

Course organization:
The course consists of lectures and laboratory exercises. The lectures cover the theoretical aspects of databases and the labs include exercises covering implementation and usage of modern database systems.

Course content:
Databse management systems. Datamodelling using the Entity-Relationship modell. Query languages for relational (SQL) and Object-oriented datamodells. Graphical query languages. Datastructures for large databases. Active databases. Data integrity. Transaction processing. Query optimization.

Course literature:
Silberschatz, Korth, Sudurshan: Database System Concepts, 3rd Ed, McGraw-Hill, 1997. Course compendium publish by the Department of Computer and Information Science.

TENAWritten examination, 3 p.
LABALabratory work, 2 p.
Course language is swedish.