IT-Universitetet i København
 
  Tilbage Kursusoversigt
Kursusbeskrivelse
Kursusnavn (dansk):Introduktion til databasedesign 
Kursusnavn (engelsk):Introduction to Database Design 
Semester:Forår 2011 
Udbydes under:cand.it., softwareudvikling og -teknologi (sdt) 
Omfang i ECTS:7,50 
Kursussprog:Engelsk 
Kursushjemmeside:https://learnit.itu.dk 
Min. antal deltagere:12 
Forventet antal deltagere:50 
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).
-----

Information about the course of study
This course is mandatory for students who are enrolled on 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. See a description of the track here: Kandidat Software Development Technology 
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 
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
•SQL
•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.
-----
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

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:Main course textbook:

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:
UgedagTidspunktForelæsning/ØvelserStedLokale
Tirsdag 12.00-14.00 Forelæsning ITU 2A14
Tirsdag 14.00-16.00 Øvelser ITU 2A52, 2A54

Eksamen afholdes på følgende tid og sted:
EksamensdatoTidspunktEksamenstypeStedLokale
2011-06-07 09:00-13:00 Skriftlig eksamen ITU 4A14 og 4A16
2011-08-23 Re-eksamen - Kontakt kursusansvarlig for tidspunkt Skriftlig eksamen ITU 4A30 - MUNDTLIG EKSAMEN