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

Timetable
Group Type Day Time Classroom Weeks Comment
Common I Monday 10-12 U82 06,08
Common I Monday 10-12 U20 07,10-13
Common I Thursday 10-12 U20 06-07,10,12
Common I Friday 12-14 U20 08
S1 TE Monday 08-10 U142 07-08,10-13
S1 TE Thursday 10-12 U145 08,11,13
S1 TE Friday 12-14 U154 07
S2 TE Monday 08-10 U49b 07-08,10-13
S2 TE Thursday 10-12 U17 08,11,13
S2 TE Friday 12-14 U142 07
S3 TE Monday 08-10 U49c 07-08,10-13
S3 TE Thursday 10-12 U24 08
S3 TE Thursday 10-12 U155 11,13
S3 TE Friday 12-14 U141 07
S4 TE Monday 08-10 U145 07-08,10-13
S4 TE Thursday 10-12 U49 08,11,13
S4 TE Friday 12-14 U146 07
Show entire timetable
 Show personal time table for this course.

Comment:
Ubegrænset deltagerantal. 3.kvartal

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.