Kursusnavn (dansk): | Introduktion til databaser |
Kursusnavn (engelsk): | Introduction to Databases |
Semester: | Efterår 2004 |
Udbydes under: | cand.it., internet- og softwareteknologi (int) |
Omfang i ECTS: | 7,50 |
Kursussprog: | Engelsk |
Kursushjemmeside: | https://learnit.itu.dk |
Min. antal deltagere: | 0 |
Forventet antal deltagere: | 60 |
Maks. antal deltagere: | 120 |
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, the student should be able to:
- 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)
- OLAP and information integration
- an overview of widely used commercial database management systems
A considerable part of the course work will consist of practical experience with implementing databases. Also, the connection between practice and the theoretical foundation is emphasized.
For more information, see the course home page for last year at <a href=http://www.itu.dk/people/pagh/IDB03>http://www.itu.dk/people/pagh/IDB03.
|
Læringsaktiviteter: | Teaching consists of lectures and exercises in English. There will be six mandatory hand-ins (both theoretical and practical) during the course. Four of the six mandatory hand-ins must be approved by the teachers for a student to attend the exam.
NB! In the introductory week, meaning from 27 August to 2 September 2004, exercises from 13:00 to 16:00 are cancelled. This means that there will be only lectures from 9:00 to 12:00 |
Eksamensform og -beskrivelse: | X. experimental examination form (7-scale; external exam), 13-skala, Ekstern censur Written exam, 4 hours. Four of six mandatory hand-ins must be approved by the teachers for a student to attend the exam.
|
Litteratur udover forskningsartikler: | Main textbook: Database Systems: The Complete Book by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom, 2002. |
| |