IT-Universitetet i København
 
  Tilbage Kursusoversigt
Kursusbeskrivelse
Kursusnavn (dansk):Introduktion til databasedesign 
Kursusnavn (engelsk):Introduction to Database Design 
Semester:Forår 2010 
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: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 provide for 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, class diagram 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 ubiquitous SQL query language for relational database systems and the interface between a typical database system and application languages such as Java.

The database system implementer is concerned with efficient 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 indexing, transactions, concurrency control, recovery systems, and security.

  • concepts of database management systems
  • the relational data model vs the object-oriented 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, object-relational mapping

 
Læringsaktiviteter:14 ugers undervisning bestående af forelæsninger og øvelser

---------
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

A mandatory group project, in three parts, as well as three out of four individual assignments, must be approved to qualify 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
0-07-295886-3.

Database Systems: A Practical Approach to Design, Implementation and
Management, 5/E by Thomas M. Connolly and Carolyn E. Begg


 
 
Afholdelse (tid og sted)
Kurset afholdes på følgende tid og sted:
UgedagTidspunktForelæsning/ØvelserStedLokale
Mandag 13.45-15.45 Forelæsning ITU Auditorium 3
Mandag 16.00-18.00 Øvelser ITU 4A54, 4A56, 4A58

Eksamen afholdes på følgende tid og sted:
EksamensdatoTidspunktEksamenstypeStedLokale
2010-06-01 09:00-13:00 Skriftlig eksamen ITU 4A14/4A16 og 2A12
2010-08-20 Mulig dag for reeksamen /Possible date for re-exam Skriftlig eksamen ITU Eksamensform kan blive ændret / Examination form may be altered
2010-08-23 Mulig dag for reeksamen /Possible date for re-exam Skriftlig eksamen ITU Eksamensform kan blive ændret / Examination form may be altered
2010-08-25 Mulig dag for reeksamen /Possible date for re-exam Skriftlig eksamen ITU Eksamensform kan blive ændret / Examination form may be altered