IV2013 Relational Database Design 7.5 credits

Relationsdatabasdesign

Level: Advanced

Offering and execution

Course offering missing for current semester as well as for previous and coming semesters

Course information

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)

Equipment

No information inserted

Literature

- 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
or
- R. Elmasri and S.B. Navathe, Fundamentals of Database Systems, Word Student Series, Addison-Wesley

Examination and completion

Grading scale *

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

Examination *

  • 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,
F.

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

Examiner

Maria Bergholtz

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

ICT/Systems Science (SU)

Main field of study *

No information inserted

Education cycle *

Second cycle

Add-on studies

No information inserted

Contact

Maria Bergholtz, maria@dsv.su.se, tfn 08-16 16 58

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.

Supplementary information

The course is given in both Swedish and English.