IT-Universitetet i København
 
  Tilbage Kursusoversigt
Kursusbeskrivelse
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 
Kursussprog:Engelsk 
Kursushjemmeside:http://www.itu.dk/courses/IDBI/E2005/index.html 
Min. antal deltagere:
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. 
 
Undervisere
Følgende personer underviser på kurset:
NavnStillingUndervisertypeIndsats (%)
Rasmus Pagh Adjunkt(ITU) Kursusansvarlig 100
Simer Singh Sawhney instruktor/hjælpelærer(ITU) Hjælpelærer 0
Priyadarsini Seetharaman instruktor/hjælpelærer(ITU) Hjælpelærer 0

Afholdelse (tid og sted)
Kurset afholdes på følgende tid og sted:
UgedagTidspunktForelæsning/ØvelserStedLokale
Mandag 13.30-16.00 Forelæsning ITU Auditorium 4
Mandag 16.00-18.30 Øvelser ITU 4A54, 4A56, 4A58

Eksamen afholdes på følgende tid og sted:
EksamensdatoTidspunktEksamenstypeStedLokale
2006-01-16 9.00-13.00 Skriftlig eksamen ITU se eksamensplan i studiehåndbogen på ITUs intranet