Hide menu

Fundamentals of modern database systems

FDA051, 2003HT

Status Archive
School Excellence Center for Computer Science and Systems Engineering in Linköping (ECSEL)
Division ADIT
Owner Nahid Shahmehri

  Log in  




Course plan

Recommended for

Ecsel's PhD students as foundational course.
All graduate students who are seeking introductory but intensive knowledge acquisition in database area.

The course was last given

Spring 2001

Goals

The aim of this course is to give a thorough introduction to the theoretical and practical issues underlying the design and implementation of modern database systems.

Prerequisites

The course is intended for PhD students who have the basics in mathematics and computer science.

Organization

The course consist of a short series of lectures, some computer labs (not mandatory) and a written exam.

Contents

Modeling (EER), relational model, mapping EER to relational model, SQL, normalization, file organization, indexing, relational algebra, query optimization, transactions, concurrency control, recovery techniques.
Please note that not all topics are covered in the seminars.

Literature

Elmasri, Navathe, Fundamentals of Database Systems, 3rd edition, Addison Wesley, 2000. ISBN 0-201-54263-3. (Available at both bookshops at the campus.)

Lecturers

* Introduction, modeling (EER), relational model, mapping EER to relational model (4h)
* Normalization, file organization, indexing (2h)
* Relational algebra, compiling queries, query optimization, transactions, concurrency control, recovery techniques (4h)
* 3/10: Object relational systems, multimedia databases, questions (2h)
Exam handed out at 8am.
Exam handed in at 4pm.

Examiner

Nahid Shahmehri

Examination

Written exam.

Credit

3 p

Comments

Practical exercises

There is a laboratory series, which is not mandatory, but is highly recommended (for instance to learn SQL). You are welcome to hand in solutions to the labs. The labs are done using the Oracle database system. The assignments are available from Bokakademin Kårallen (with course code TDDB38 or TDDB48).


Page responsible: Director of Graduate Studies