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: seg@imada.sdu.dk

Timetable

Group	Type	Day	Time	Classroom	Weeks
Common	I	Monday	12-14	U28	05-09,11
Common	I	Wednesday	10-12	U28	05-06, 08, 10
Common	I	Thursday	12-14	U144	10
S7	TE	Monday	14-16	U142	10
S7	TE	Wednesday	10-12	U28	07, 09, 11
S7	TE	Thursday	12-14	U144	05-09,11

Show entire timetable
Show personal time table for this course.

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

Meddeles ved kursets start.

Syllabus
See syllabus.

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.