|Kursusnavn (dansk):||Introduktion til databaser |
|Kursusnavn (engelsk):||Introduction to Databases |
|Semester:||Efterår 2005 |
|Udbydes under:||cand.it., internet- og softwareteknologi (int) |
|Omfang i ECTS:||7,50 |
|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 course along with introductory programming. However, for students taking this as a first course, some mathematical background (such as A level high school 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 or UML 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
- create database constraints such as referential integrity
- apply the basic ways of improving database efficiency
- analyze the behavior of concurrent transactions
|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 or UML
- 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 http://www.itu.dk/people/pagh/IDB04.
|Læringsaktiviteter:||12 forelæsninger og 12 øvelsesgange|
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 29 August to 2 September 2005, excercises are cancelled. Lectures are from 16:00 to 18:30.
|Eksamensform og -beskrivelse:||A2: Skriftlig eksamen med alle skriftlige og trykte hjælpemidler, 13-skala, Ekstern censur|
|Litteratur udover forskningsartikler:||Main textbook: Database Systems: The Complete Book by Hector Garcia-Molina,
Jeff Ullman, and Jennifer Widom, 2002.