Department of Informatics

Lund University School of Economics and Management

Advanced Database Systems

INFC20, Informatics, 7.5 ECTS credits

The course is offered on the fifth term of the Bachelor's programme in Design of Information Systems, to exchange students and as a freestanding course.

Course description

The course presupposes a basic knowledge of conceptual modelling for data base systems and implementation using relational DBMS and SQL. The course aims to a more profound understanding of database theories, models, and methods and an ability to use these in different situations.

Course content:

  • Database systems concepts and architecture
  • Concepts used in UML, EER, and XML.
  • Transformation of conceptual models to a relation. Properties of normalisation up to 4NF.
  • Views, implementation of integrity constraints.
  • Centralised, decentralised and distributed databases.
  • Transaction handling. Concurrency and recovery. Query optimization. Advanced and embedded SQL. Triggers and stored procedures.
  • The problem of using different architectures in client and server side applications.
  • Techniques for efficient storing, accessing, securing, and recovering of data.
  • Implementation of advanced structures in relational, hybrid, and object oriented data bases.
  • Techniques for distributed data bases.

Teaching methods and examination: Lectures, lessons, laboratory work. Written test and assignments.


Björn Svensson
Lecturer, director of studies
Phone: +46 46 222 81 83
Room: EC2-281

Björn Svensson

Additional information

​Course syllabus, in English
Course syllabus, in Swedish

Reading list for Autumn 2022

Basic level G2F
Teaching language: English
Offered: Autumn semester



Schedules for all our courses are published electronically in TimeEdit.

You find instructions how to search for your course schedule in the pdf-document TimeEdit - find your schedule.