Group | Type | Day | Time | Classroom | Weeks | Comment |
---|---|---|---|---|---|---|
Common | I | Monday | 12-14 | U9 | 06-12 | |
Common | I | Thursday | 10-12 | U9 | 06,08,10,12 | |
S71 | TE | Wednesday | 10-12 | U9 | 06-12 | |
S71 | TE | Thursday | 10-12 | U148 | 07 | |
S71 | TE | Thursday | 10-12 | U9 | 09,11 |
Ubegrænset deltagerantal. 3. kvartal.
Prerequisites:
None
Academic preconditions:
The content of DM502 Programming A and DM503 Programmering B must be known.
Course introduction
To give the student theoretical skills and practical experience in the
use, design, and implementation of a relational database.
Expected learning outcome
After the course, the student is expected to be able to:
• design a suitable ER-model for a database, on the basis of a problem description
• transform an ER-model for a database into a suitable relational model
• write SQL queries for a relational database
• optimize a relational database through choice of indexes, use of equivalent SQL-expressions, and use of the theory of normal forms
• access a databse from an application program.
• describe work done on the above subjects in clear and precise language, and in a structured fashion
Subject overview
Relational databases, database design (ER-modelling, normal forms), relational algebra, SQL, database access from application programs, basic disk structure, index use and index implementations (hashing based, tree based).
Literature