DM505: Database Design and Programming (5 ECTS)
STADS: 15005101Level
Bachelor course
Teaching period
The course is offered in the spring semester.
Third quarter.
Teacher responsible
Email: jbaumbac@imada.sdu.dkTimetable
| Group | Type | Day | Time | Classroom | Weeks | Comment |
|---|---|---|---|---|---|---|
| Common | I | Wednesday | 10-12 | U55 | 5-7,9-11,13 | |
| Common | I | Thursday | 10-12 | U55 | 5 | |
| Common | I | Thursday | 14-16 | U55 | 7,10,13 | |
| D2 | TE | Tuesday | 12-14 | U154 | 6 | |
| D2 | TE | Tuesday | 12-14 | U14 | 9 | |
| D2 | TE | Tuesday | 12-14 | U31 | 11 | |
| D2 | TE | Friday | 12-14 | U14 | 5,7 | |
| D2 | TE | Friday | 12-14 | U27A | 6 | |
| D2 | TE | Friday | 12-14 | U156 | 9-11,13 | |
| D3 | TE | Monday | 10-12 | U155 | 6,11 | |
| D3 | TE | Monday | 10-12 | U51 | 9 | |
| D3 | TE | Friday | 10-12 | U155 | 5-7,9-11,13 | |
| OR | Thursday | 10-12 | U55 | 5 | ||
| OR | Thursday | 08-10 | U23A | 7,9-11,13 | ||
| OR | Friday | 14-16 | U142 | 9,11 | ||
| T1 | TE | Thursday | 08-10 | U23A | 5-7,9-11,13 | |
| T1 | TE | Friday | 14-16 | U142 | 6,9,11 | |
| T2 | TE | Wednesday | 12-14 | U146 | 5-6 | |
| T2 | TE | Wednesday | 12-14 | U14 | 7,13 | |
| T2 | TE | Wednesday | 12-14 | U31 | 9-11 | |
| T2 | TE | Friday | 08-10 | U14 | 6 | |
| T2 | TE | Friday | 08-10 | U51 | 9,11 |
Show personal time table for this course.
Comment:
Ubegrænset deltagerantal.
Prerequisites:
None
Academic preconditions:
The content of DM536 Introduction til Programming” and DM537 Object-oriented Programming” OR DM550 Introduction to Programming must be known. Basic knowledge about modelling of software systems is also assumed.
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 conceptual model for a database, on the basis of a problem description
- transform a conceptual 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 database from an application program.
- describe work done on the above subjects in clear and precise language, and in a structured fashion
Relational databases, database design (conceptual data modelling, normal forms), relational algebra, SQL, database access from application programs, basic disk structure, index use and index implementations (hashing based, tree based).
Literature
- Meddeles ved kursets start.
Website
This course uses e-learn (blackboard).
Prerequisites for participating in the exam
None
Assessment and marking:
Project and 1-day take-home exam, for which one combined grade is given. Project and take-home exam count equally in the grade. Grades according to the 7-point marking scale. External examiner.
Examination when the course has been taught. Re-examination after 4th quarter. The re-examination is an oral exam, grades according to the 7-point marking scale, internal examiner.
Expected working hours
The teaching method is based on three phase model.
Forelæsninger (22 timer), eksaminatorier (20 timer) og projektarbejde.
Educational activities
Language
This course is taught in Danish or English, depending on the lecturer.
Course enrollment
See deadline of enrolment.
Tuition fees for single courses
See fees for single courses.
