Relational databases, object oriented and object relational databases, and semistructured databases are examined with regard to different aspects. All database types have advantages and disadvantages. Advanced business logic and multimedia support set new requirements of database functionality. Semistructured databases (web databases) are becoming more and more common, especially when combined with other Internet functionality and the Semantic Web. This course deals with the different areas of applications of databases, as well as aspects of the different models, languages, and database management systems. Theory about relational databases, object databases and semistructured (web) databases. Areas of application. Comparison of database models. Comparison of database languages for: - relational databases: relational algebra, relational calculus, SQL - object databases: OQL, ODQL - web databases: Lorel, XQuery, DB2XMLQL Embedded database languages (with Java as the host language).
Intended learning outcomes *
After receiving a passing grade for this course, a student shall:- be familiar with the theory and the principles of database construction.- understand the different areas of application of the different database types, as well as their limitations.- be familiar with interactive and embedded database languages.- have knowledge about the different database types necessary for choosing a database manager given a particular problem.- be empowered to compare the different database models and languages- be empowered to practically work with a database
Completion of upper secondary education incl profiency in Swedish and English.
Basic knowledge of object-orientation, databases, programming and XML/HTML. This course requires that the students are a bit familiar with HTML/XML.
No information inserted
Connolly, Begg: : Database Systems A Practical Approach to Design, Implementation and ManagementUpplaga : 4 ISBN 0-321-21025-5Course material:- Course Information- Computer Environment Tutorials- Collection of articles and excerptsReference literature
Examination and completion
Grading scale *
A, B, C, D, E, FX, F
Grading scale: P, F
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 examination includes:- Exercises presented at seminars- Written exam- Assignments with oral presentation & hand-inExam 3 ECTS credits (A-F)Seminar exercises and assignments 4,5 ECTS credits (Pass/Fail)The exam is divided in 5 parts that cover the five main areas of the course:- Modeling- Query languages for relational databases- Query languages for object databases- Embedded query languages- Semistructured databases and XML (including query languages)
Opportunity to complete the requirements via supplementary examination
No information inserted
Opportunity to raise an approved grade via renewed examination