DM505: Database Design and Programming (5 ECTS)

STADS: 15005101

Level
Bachelor course

Teaching period
The course is offered in the spring semester.
Third quarter.

Teacher responsible
Email: jbaumbac@imada.sdu.dk

Timetable
Group Type Day Time Classroom Weeks Comment
Common I Tuesday 14-16 U140 6
Common I Tuesday 12-14 U45 7-8,10-13
Common I Thursday 12-14 U140 6,8
Common I Thursday 12-14 U1 11,13
D1 TE Wednesday 10-12 U157 6-8,10-13
D1 TE Thursday 14-16 U156 7,10,12
D2 TE Wednesday 12-14 U8 6-8,10-13
D2 TE Thursday 16-18 U154 7,10,12
H1 TE Wednesday 14-16 U156 6-7,10-13
H1 TE Thursday 12-14 U154 7,10,12
H1 TE Thursday 14-16 U142 8
T1 TE Tuesday 12-14 U154 6
T1 TE Tuesday 14-16 U24 7-8,10-13
T1 TE Thursday 08-10 U154 7,10,12
T2 TE Tuesday 10-12 U156 6-8,10-13
T2 TE Thursday 10-12 U157 7,10,12
Show entire timetable
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” 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
Subject overview
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.