IT-Universitetet i København
  Tilbage Kursusoversigt
Kursusnavn (dansk):Introduktion til databasedesign 
Kursusnavn (engelsk):Introduction to Database Design 
Semester:Forår 2012 
Udbydes, softwareudvikling og -teknologi (sdt) 
Omfang i ECTS:7,50 
Min. antal deltagere:12 
Forventet antal deltagere:20 
Maks. antal deltagere:70 
Formelle forudsætninger:This course assumes basic ability to use a computer. We also assume that a student is taking an introductory programming course in parallel (otherwise basic programming skills in Java are expected) and following a discrete math course such as SGDM in parallel (or has knowledge of basic discrete math (logic, set theory and proofs)).


Information about the course of study
This course is mandatory for students who are enrolled on on the Master of Science in IT, study programme Software Development and Technology, Development Technology track. 
Læringsmål:After the course the student should be able to:

•Model structuring of data within the relational framework
•Model data domains using ER diagrams
•Create and implement database designs
•Analyze and improve database designs using normal form theory
•Use relational algebra to explain semantics of the query language
•Work with SQL to create, query, update, and perform basic level administration tasks on a relational database
•Analyze/predict/improve efficiency of the designed database using indices
•Use transactions to provide concurrent data access 
Fagligt indhold:Database systems are the foundation of many computer and web applications today. They guarantee the persistent and reliable storage and use of shared information.

This course presents database systems from three points of view: the database designer, the database user and applications programmer, and the database system implementer.

The database designer is concerned with the modeling and structure of data. Modeling techniques to be covered include the entity-relationship model, the relational model, the relational calculus, integrity constraints, functional dependencies, and normal forms.

The database user and applications programmer need to know how the data model is represented in modern database systems, and how to store and retrieve data from such systems. The course will cover the SQL query language for relational database systems and (if time permits) the interface between a typical database system and application languages such as Java or Ruby.

The database system implementer is concerned with efficient and reliable storage and retrieval of data in a concurrent, distributed environment. The course will give an insight into database implementation, including indexing, transactions, concurrency control, recovery systems, and security.

•concepts of database management systems
•relational data model
•the entity-relationship data model
•theoretical foundation of SQL and database design (relational algebra and normalization)
•efficient database implementation
•transactions and concurrency control
•time permitting, integration of databases in IT systems, object-relational mapping 
Læringsaktiviteter:14 ugers undervisning bestående af forelæsninger og øvelser

Written mandatory individual assignments + individual programming.

There will be a TA session, where the students can work together/get help from the TA.

NB!! Course restriction!!
Please note that there is a course restriction between this course and the SDT course Database Systems.
That means that you cannot take this course, if you have already taken Database Systems. 

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

This course has mandatory assignments (e.g. attendance, papers, exercises, presentations, productions), that need to be completed/approved before being eligible to register for the examination:
- Written mandatory individual assignments + individual programming.  

Litteratur udover forskningsartikler:Abraham Silberschatz, Henry F. Korth, and S. Sudarshan,
Database System Concepts (Sixth Edition), WCB/McGraw-Hill
ISBN 0-07-352332-1. 
Afholdelse (tid og sted)
Kurset afholdes på følgende tid og sted:
Mandag 12.00-13.50 Øvelser ITU 4A54, 4A56
Mandag 14.00-15.50 Forelæsning ITU Aud 3

Eksamen afholdes på følgende tid og sted:
2012-06-06 9-13 Skriftlig eksamen ITU 4A14/16