DM505: Database Design and Programming
Study Board of Science
Teaching language: Danish or English depending on the teacher, but English if international students are enrolled
EKA: N330029102
Assessment: Second examiner: External
Grading: 7-point grading scale
Offered in: Odense
Offered in: Spring
Level: Bachelor
STADS ID (UVA): N330029101
ECTS value: 5
Date of Approval: 05-11-2019
Duration: 1 semester
Version: Archive
Comment
15005101(former UVA) is identical with this course description.
The course is co read with: Database Systems (10 ECTS).
The course is co read with: Database Systems (10 ECTS).
Entry requirements
Academic preconditions
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.
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
Content
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
- database systems
Literature
Examination regulations
Exam element a)
Timing
Spring
Tests
1-day take-home exam
EKA
N330029102
Assessment
Second examiner: External
Grading
7-point grading scale
Identification
Full name and SDU username
Language
Normally, the same as teaching language
Duration
24 hours
Examination aids
To be announced during the course
ECTS value
5
Additional information
None.
Re-examination
Assessment
Second examiner: Internal
Grading
7-point grading scale
Identification
Student Identification Card
Language
Normally, the same as teaching language
Examination aids
Will be announced prior to the exam
ECTS value
5
Additional information
Oral re-examination.
Indicative number of lessons
Teaching Method
The course consists of partially interactive lectures (22 hours), exercise sessions (20 hours), and reading and study activities at home or in study groups.