2025 Spring 2024 Spring 2023 Spring 2022 Spring 2021 Spring 2020 Spring 2019 Spring 2018 Spring 2017 Spring 2016 Spring 2015 Spring 2014 Spring 2013 Spring 2012 Spring 2011 Spring 2010 Spring 2009 Spring 2008 Spring 2007 Spring 2006 Spring
Show the courses of study containg this course Se overgangsordninger
Dansk English

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.