DM505: Databases (5 ECTS)

STADS: 15000501

Level
Bachelor course

Teaching period
The course is offered in the spring semester.
Fourth quarter of Science Year.

Teacher responsible
No responsible teachers found, contact the department if necessary

Timetable
Show entire timetable
Show personal time table for this course.

Prerequisites:
None

Academic preconditions:
The content of DM502 Programming A and DM503 Programmering B must be known.

Course introduction
To give an introduction to the central aspects of relational database systems.

Competences:
The students will gain theoretical knowledge as well as practical experience regarding the design and implementation of efficient relational databases. This includes an understanding of essential implementation techniques used in relational database systems. After the course, the students are expected to be able to

• design a suitable ER-model for a database, given a requirement description.
• transform an ER-model into a relational model, and further into a physical database on a relational database system.
• write and execute SQL expressions on a relational database system.
• optimize a relational database through choice of indexes, rewriting of SQL queries, and use of normal forms.
• write application programs accessing a relational database.

Expected learning outcome


Subject overview
Relational databases, database design (ER-modelling, normal forms), relational algebra, SQL, database access from application programs, basic disk structure, index implementations (hashing based, tree based), concurrency control.

Literature
There isn't any litterature for the course at the moment.

Syllabus
See syllabus.

Website
This course uses e-learn (blackboard).

Prerequisites for participating in the exam
None

Assessment and marking:
Oral exam with an external examiner (censor). Grades according to the 13-point scale.
A mandatory project (pass/fail) must have been approved in order to take the exam.

Examination only when the course has been taught. Examination in other terms only after acceptance from the study board.

Expected working hours
The teaching method is based on three phase model.

Forelæsninger (22 timer), eksaminatorier (20 timer) og projektarbejde.
Educational activities

Language
No recorded information about the language used in the course.

Course enrollment
See deadline of enrolment.

Tuition fees for single courses
See fees for single courses.