IT-Universitetet i København
  Tilbage Kursusoversigt
Kursusnavn (dansk):Introduktion til databasedesign 
Kursusnavn (engelsk):Introduction to Database Design 
Semester:Efterår 2010 
Udbydes, softwareudvikling og -teknologi (sdt) 
Omfang i ECTS:7,50 
Min. antal deltagere:
Forventet antal deltagere:45 
Maks. antal deltagere:65 
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).  
Læringsmål:After the course the student should be able to:

•Model structuring of data within the relational framework
•Model data and software domains using UML class diagrams
•Create/Analyze/Evaluate/Implement database designs.
•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/predicte/improve efficiency of the designed database
•Use transactions to provide concurrent data access
•Use relational databases to store data modeled using classes and objects
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 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.

Study structure
This course is mandatory for students who are enrolled on the Development Technology track on SDT. See the track described here:
Development Technology.
See the schedule here:
link to the time table
The schedule will be available shortly before the beginning of the term.
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

Students must hand in 6 mandatory assignments and 50% of these must be passed in order to be eligible for the exam.

Litteratur udover forskningsartikler:Main course textbook:

Abraham Silberschatz, Henry F. Korth, and S. Sudarshan,
Database System Concepts (Fifth Edition), WCB/McGraw-Hill,ISBN

Afholdelse (tid og sted)
Kurset afholdes på følgende tid og sted:
Onsdag 08.30-10.30 Forelæsning ITU 3A14
Onsdag 10.45-12.45 Øvelser ITU 4A54, 4A56, 4A58

Eksamen afholdes på følgende tid og sted:
2011-01-05 09:00-13:00 Skriftlig eksamen ITU 4A14 og 4A16
2011-02-18 Re-eksamen Skriftlig eksamen ITU 2A14