DM505: Database Design and Programming (5 ECTS)

STADS: 15005101

Level
Bachelor course

Teaching period
The course is offered in the spring semester.

Teacher responsible
Email: jbaumbac@imada.sdu.dk

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

Comment:
Ubegrænset deltagerantal.

Prerequisites:
None.

Academic preconditions:
Students taking the course are expected to:

• Have knowledge in programming in Java.
• Have proficiency in programming in general.

Course introduction
The purpose of this course is to give the student theoretical skills and practical experience in the use, design, and implementation of a relational database.

The content of DM550 – Introduction to Programming must be known. Basic knowledge about modelling of software systems is also assumed.

The course provides the basis for the course ‘principles of database systems’

In relation to the learning outcomes 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
• 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 objectives 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 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
• justify design conditions
• describe, formulate and communicate issues and results to specialists and non-specialists, or project partners and end users

Subject overview
The following main topics are contained in the course:

• 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

1. Project assignments are a prerequisite for participation in the exam element a). Pass/fail, internal evaluation. (15005112).

Assessment and marking:

1. 1-day take-home exam. (5 ECTS). Graded according to the Danish 7-mark scale, external examiner. (15005102).

Oral re-examination. Internal examiner. 7-mark-scale.

Expected working hours
The teaching method is based on three phase model.
Intro phase: 22 hours
Skills training phase: 20 hours, hereof:
 - Tutorials: 20 hours

Educational activities

Educational form
In the intro phase, concepts, theories and models are introduced and put into perspective. In the training phase, students train their skills through exercises and dig deeper into the subject matter. In the study phase, students gain academic, personal and social experiences that consolidate and further develop their scientific proficiency. Focus is on immersion, understanding, and development of collaborative skills.

Language
This course is taught in Danish or English, depending on the lecturer. However, if international students participate, the teaching language will always be English.

Course enrollment
See deadline of enrolment.

Tuition fees for single courses
See fees for single courses.