lunduniversity.lu.se

Department of Informatics

Lund University School of Economics and Management

INFC20, Advanced Database Systems

Informatics, 7.5 ECTS credits

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

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.

 

Erdogan Ucan
Lecturer

erdogan.ucan@ics.lu.se
Phone: +46 46 222 47 97
Room: EC2-269

Additional information

​Course syllabus, in English
Course syllabus, in Swedish

Reading list for Autumn 2017


Basic level G2F
Teaching language: English
Offered: Autumn term

 

Schedule

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.