Kursusbasen

Kursusoversigt

Kursusbeskrivelse

Kursusnavn (dansk):	Databasesystemer
Kursusnavn (engelsk):	Database Systems
Semester:	Efterår 2009
Udbydes under:	cand.it., softwareudvikling og -teknologi (sdt)
Omfang i ECTS:	7,50
Kursussprog:	Engelsk
Kursushjemmeside:	https://learnit.itu.dk
Min. antal deltagere:	0
Forventet antal deltagere:	45
Maks. antal deltagere:	65
Formelle forudsætninger:	This course assumes basic computer science background. It requires that the participants have taken the introductory programming courses and the modeling course for the Software Development and Technology study programme.
Læringsmål:	Database systems are the foundation of many computer and web applications today. They provide for the persistent and reliable storage and use of shared information. Create/Analyze/Evaluate/Implement database designs. Understand/work with relational algebra. Understand the foundations of query language. Understand/work with SQL Analyze/predicte/improve efficency. Understand/Use transactions.
Fagligt indhold:	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 needs 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 ubiquitous SQL query language for relational database systems and the interface between a typical database system and application languages such as C and C++. The database system implementer is concerned with efﬁcient and reliable storage and retrieval of data in a concurrent, distributed environment. The course will give a brief overview of many topics involved in database implementation, including ﬁle structures, indexing, query processing, transactions, concurrency control, recovery systems, and security. 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
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. ------------------------------------- Information about study structure This course is part of the SDT specialization Databases- find it described here: SDT specializations In order to graduate as a MSc in SDT, you need to pass the SDT backbone courses, and also take a 22,5 ECTS specialization and two 7,5 ECTS electives. ------------ See the schedule here: link to the time table The schedule will be available shortly before the beginning of the term.
Eksamensform og -beskrivelse:	X. experimental examination form (7-scale; external exam), 7-trins-skala, Ekstern censur Qualification for the exam: pass on 80% of the assignments + pass on the project
Litteratur udover forskningsartikler:	Main course textbook: Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Database System Concepts (Fifth Edition), WCB/McGraw-Hill,ISBN 0-07-295886-3.

Afholdelse (tid og sted)

Kurset afholdes på følgende tid og sted:

Ugedag	Tidspunkt	Forelæsning/Øvelser	Sted	Lokale
Mandag	09.00-12.00	Forelæsning	ITU	4A54, 4A56 (Teaching from 11-13 PM)
Mandag	09.00-12.00	Øvelser	ITU	4A14 (Teaching from 9-11 PM)

Eksamen afholdes på følgende tid og sted:

Eksamensdato	Tidspunkt	Eksamenstype	Sted	Lokale
2010-01-05	09:00-13:00	Skriftlig eksamen	ITU	4A14/4A16