DM564: Database Systems

Study Board of Science

Teaching language: Danish or English depending on the teacher, but English if international students are enrolled
EKA: N330040102, N330040112
Assessment: Second examiner: External, Second examiner: Internal
Grading: 7-point grading scale
Offered in: Odense
Offered in: Spring
Level: Bachelor

STADS ID (UVA): N330040101
ECTS value: 10

Date of Approval: 28-10-2018


Duration: 1 semester

Version: Archive

Comment

The course is co-read with: DM505, SI2-PDB

Entry requirements

None

Academic preconditions

Students taking the course are expected to:

  • have knowledge of programming
  • be able to program

Course introduction

The purpose of this course is to give the student theoretical skills and practical experience in the use, design, and implementation of relational databases and database systems. 
The course builds on the knowledge obtained in DM550 Introduction to Programming. Basic knowledge about modelling of software systems is also assumed. 
In relation to the competence profile of the degree the course has explicit focus on:
  • giving the competence to plan and design a relational database
  • knowledge of structured querying and manipulating relational databases
  • application of a relational database system to model real world data
  • developing skills in the programming of database applications
  • understanding for the internal structure of database systems
  • application of knowledge about database systems framed by realistic projects
  • giving the competences to handle complex and development-oriented situations in study and work contexts
  • skills to identify own learning needs and to structure own learning in different learning environments

Expected learning outcome

The learning objective of the course is that the student demonstrates the ability 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 the use of equivalent SQL-expressions, as well as through the use of the theory of normal forms
  • access a database from an application program.
  • exploit the understanding for the structure of database systems to optimize their application
  • integrate database systems framed by realistic projects
  • describe work done on the above subjects in clear and precise language, and in a structured fashion
  • justify design conditions
  • describe, formulate and communicate issues and results to specialists and non-specialists, or project partners and end users

Content

The following main topics are contained in the course:

  • relational databases
  • database design (conceptual data modelling, normal forms)
  • relational algebra
  • SQL
  • integration of databases in applications
  • database systems

Literature

See Blackboard for syllabus lists and additional literature references.

Examination regulations

Exam element b)

Timing

Spring

Tests

1-day take-home exam

EKA

N330040102

Assessment

Second examiner: External

Grading

7-point grading scale

Identification

Student Identification Card

Language

Normally, the same as teaching language

Duration

24 hours

Examination aids

To be announced during the course

ECTS value

5

Additional information

The examination form for re-examination may be different from the exam form at the regular exam. 

Exam element a)

Timing

May/June

Tests

Project

EKA

N330040112

Assessment

Second examiner: Internal

Grading

7-point grading scale

Identification

Full name and SDU username

Language

Normally, the same as teaching language

Examination aids

All aids allowed.

ECTS value

5

Additional information

The examination form for re-examination may be different from the exam form at the regular exam. 

Indicative number of lessons

60 hours per semester

Teaching Method

The course has a progression from a necessary focus on design and theory towards the languages that bridge theory and practice, ending with real-world applications. The teaching methods likewise progress from frontal lectures and exercises to project work..

Activities during the study phase:

  • Software development in teams
  • Specification, evaluation, and use of application, which are based on databases

Teacher responsible

Name E-mail Department
Peter Schneider-Kamp petersk@imada.sdu.dk

Timetable

Administrative Unit

Institut for Matematik og Datalogi (datalogi)

Team at Educational Law & Registration

NAT

Offered in

Odense

Recommended course of study