|Kursusnavn (dansk):||Introduktion til databaser (kl. 13.00 - 19.00) |
|Kursusnavn (engelsk):||Introduction to Databases (13:00 - 19:00) |
|Semester:||Efterår 2003 |
|Udbydes under:||cand. it, softwareudvikling (swu) |
|Omfang i ECTS:||7,50 |
|Min. antal deltagere:||0 |
|Forventet antal deltagere:||20 |
|Maks. antal deltagere:||40 |
|Formelle forudsætninger:||No formal prerequisites. The course may be taken as a first programming course. However, some mathematical background (such as A level high school mathematics or the course IT Mathematics) is an advantage. |
|Læringsmål:||The goal of the course is to provide students with a firm background in database implementation. After the course, the student should be able to:|
- Design and implement moderate size relational databases. In particular:
- Make a database design in the entity-relationship model and convert it to the relational model.
- Program complex queries in SQL.
- Use theoretical tools such as normalization and relational algebra to improve database design and implementation.
- Understand the basics of database efficiency.
- Understand important database management system concepts such as transactions, concurrency, and error recovery.
- Know about issues and tools in information integration.
- Know about some widely used commercial database management systems.
|Fagligt indhold:||The course is an introduction to relational databases (the dominant database paradigm), covering their design, implementation, and theoretical foundation. The course focuses in particular on the skills needed to design and implement databases. It covers the following topics:|
- The relational data model.
- Programming database queries in SQL.
- Database design using the entity-relationship data model.
- Theoretical foundation of SQL and database design (relational algebra and normalization).
- Efficient database implementation.
- Properties of database management systems (transactions, concurrency, error recovery).
- Information integration (using XML).
- An overview of widely used commercial database management systems.
A considerable part of the coursework will consist of practical experience with implementing databases. Also, the connection between practice and the theoretical foundation is emphasized.
Teaching consists of lectures and exercises in English.
There will be a number of mandatory hand-ins (both theoretical and practical) during the course.
|Eksamensform og -beskrivelse:||X. experimental examination form (7-scale; external exam), 13-skala, Ekstern censur|
Written exam, 4 hours. Satisfactory mandatory hand-ins required to enter exam.
|Litteratur udover forskningsartikler:||Main textbook:|
Database Systems: The Complete Book
by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom, 2002.
See the course home page www.itu.dk/people/pagh/IDB03/ for supplementary literature.