Skip to main content

IV2013 Relational Database Design 7.5 credits

Level: Advanced

Course offering missing for current semester as well as for previous and coming semesters
Headings with content from the Course syllabus IV2013 (Autumn 2008–) are denoted with an asterisk ( )

Content and learning outcomes

Course contents

Database modelling - best practices, analysis patterns and data-abstractions, schema integration. Design aspects on transformation of a conceptual model into a logical relational database schema. Analytical database design. Database architechture for multimedia data and their realization in DB2 via text, image, audio and video extenders. Optimization of SQL-transactions. Parallellism. Balancing of application demands. Application of views. Guidelines for choice of index and physical allocation. File organisations and access methods. Segmentation, replication and partitioning.

Intended learning outcomes

The course is an advanced course in logical and physical design of relational databases including the representation of multimedia in relational databases. Given a number of user demands a normalised relational schema is developed. The schema is then translated into a physical database schema optimized with respect to a set of transactions. IBM DB2 version 8.2 is used to exemplify implementing and optimizing a relational database.

Course disposition

Lectures, seminars and computer-aided assignments.

Literature and preparations

Specific prerequisites

A basic course in relational database design (or corresponding knowledge)

Recommended prerequisites

A basic course in relational database design (or corresponding knowledge)


No information inserted


- Collection of excerpts from the following books: Flemming von Halle: Handbook of relational database design, Gulutzan: SQL- Performance Tuning, Fowler: Analysis patterns, Odell: Object Oriented methods: A foundation, Rick van der Lans: Introduction to SQL, Lynne Dunckley: Multimedia Databases: An Object-Relational Approach R. Elmasri and S.B. Navathe: Fundamentals of Database Systems, T. Connolly and C. Begg: Database Systems: A Practical Approach to Design, Implementation, and Management
- Article collection
- Manuals and other material
Reference litterature:
One complete, basic database course-book is assumed from an earlier basic course in relational database design. We suggest:
- T. Connolly and C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, Addison-Wesley
- R. Elmasri and S.B. Navathe, Fundamentals of Database Systems, Word Student Series, Addison-Wesley

Examination and completion

If the course is discontinued, students may request to be examined during the following two academic years.

Grading scale

A, B, C, D, E, FX, F


  • INL1 - Assignment, 1.5 credits, grading scale: P, F
  • INL2 - Assignment, 1.5 credits, grading scale: P, F
  • SEM1 - Seminar, 1.5 credits, grading scale: P, F
  • TEN1 - Examination, 3.0 credits, grading scale: A, B, C, D, E, FX, F
Based on recommendation from KTH’s coordinator for disabilities, the examiner will decide how to adapt an examination for students with documented disability.

The examiner may apply another examination format when re-examining individual students.

The course examination is divided into four parts:
Seminars (1,5hp) grading scale P/F.
Assignment I (1,5 hp) grading scale P/F.
Assignment II (1,5 hp) grading scaleP/F.
Written exam (3hp), grading scale A, B, C, D, E, Fx,

Other requirements for final grade

To pass the course, the student needs to pass on all four examination parts. Course grade is based on the grade on the written exam.

Opportunity to complete the requirements via supplementary examination

No information inserted

Opportunity to raise an approved grade via renewed examination

No information inserted


Ethical approach

  • All members of a group are responsible for the group's work.
  • In any assessment, every student shall honestly disclose any help received and sources used.
  • In an oral assessment, every student shall be able to present and answer questions about the entire assignment and solution.

Further information

Course web

Further information about the course can be found on the Course web at the link below. Information on the Course web will later be moved to this site.

Course web IV2013

Offered by

Main field of study

This course does not belong to any Main field of study.

Education cycle

Second cycle

Add-on studies

No information inserted


Maria Bergholtz,, tfn 08-16 16 58

Supplementary information

The course is given in both Swedish and English.