Swedish web site
Fundamentals of modern database systemsFDA051, 2004HT
|
|
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
2003
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 consists of a short series of lectures/seminars, 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 or 4rd edition, Addison Wesley, 2000 or 2004. ISBN 0-201-54263-3 or 0-321-20448-4. (Available at both bookshops at the campus.)
Lecturers
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
