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.
IV2013 Relational Database Design 7.5 credits
This course has been discontinued.
Last planned examination: Spring 2000
Decision to discontinue this course:
No information insertedContent and learning outcomes
Course contents
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.
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
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
If the course is discontinued, students may request to be examined during the following two academic years.
Grading scale
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
Opportunity to raise an approved grade via renewed examination
Examiner
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 room in Canvas
Offered by
Main field of study
Education cycle
Add-on studies
Contact
Supplementary information
The course is given in both Swedish and English.