IT-Universitetet i København
 
  Tilbage Kursusoversigt
Kursusbeskrivelse
Kursusnavn (dansk):Databasesystemer 
Kursusnavn (engelsk):Database Systems 
Semester:Efterår 2007 
Udbydes under:cand.it., softwareudvikling og -teknologi (sdt) 
Omfang i ECTS:7,50 
Kursussprog:Engelsk 
Kursushjemmeside:https://learnit.itu.dk 
Min. antal deltagere:
Forventet antal deltagere:45 
Maks. antal deltagere:65 
Formelle forudsætninger:The course assumes that students have some experience with a modeling notation such as UML or E/R diagrams, and have written short programs in a programming or scripting language (e.g. java, php, or visual basic). This can, for example, be fulfilled by taking the module "Modelling and Design". These prerequisites are not essential in the sense that it is possible to take the course without fulfilling them, but some parts will then require more work.
 
Læringsmål:Databases are found everywhere in IT systems, as the fundamental mechanism for storing and accessing large, structured data sets. The overall goal of the course is to provide you with a background for designing and implementing databases based on the relational model (the dominant database paradigm). In particular, after the course you should be able to:

  • make a database design in the entity-relationship model or UML and convert it to the relational model
  • use theoretical tools such as normalization and relational algebra to improve database design and implementation
  • create database constraints such as referential integrity
  • program complex queries in SQL
  • apply the basic ways of improving database efficiency
  • analyze the behavior of concurrent transactions

 
Fagligt indhold:The course is an introduction to relational databases, 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:

  • concepts of database management systems
  • the relational data model
  • database design using the entity-relationship data model or UML
  • programming database queries in SQL
  • theoretical foundation of SQL and database design (relational algebra and normalization)
  • efficient database implementation
  • transactions and concurrency control
  • integration of databases in IT systems

A considerable part of the course work will consist of practical experience with designing and implementing databases. In particular, the course includes a small, mandatory database development project. The connection between practice and the theoretical foundation is emphasized.
 
Læringsaktiviteter:14 ugers undervisning bestående af forelæsninger og øvelser

A mandatory group project, in three parts, as well as two put of three individual assignments, must be approved to qualify for the exam.
 

Eksamensform og -beskrivelse:X. experimental examination form (7-scale; external exam), 7-trins-skala, Ekstern censur

 

Litteratur udover forskningsartikler:Main course textbook:
Database Management Systems, 3rd rev. edition, by Raghu Ramakrishnan and Johannes Gehrke,
McGraw-Hill, 2002. ISBN: 0071230572

Students interested in how databases are used in business systems may find the following book useful as supplementary literature:
Modern Database Management, 8th edition, by Jeffery A. Hoffer, Mary B. Prescott and Fred R. McFadden, International edition, Prentice Hall, 2004. ISBN 0131453203

Students interested in databases mainly from the programming point of view may find the following book useful as supplementary literature:
SQL Clearly Explained, by Jan L. Harrington, Morgan Kaufmann, 2003. ISBN 1558608761.
 
 
Afholdelse (tid og sted)
Kurset afholdes på følgende tid og sted:
UgedagTidspunktForelæsning/ØvelserStedLokale
Tirsdag 17.00-19.00 Forelæsning ITU 4A14
Tirsdag 19.00-21.00 Øvelser ITU 4A56, 4A58

Eksamen afholdes på følgende tid og sted:
EksamensdatoTidspunktEksamenstypeStedLokale
2008-01-04 9:00-13:00 Skriftlig eksamen ITU Lokale oplyses senere