Recommended prerequisite for participation in the module

The module builds on the knowledge gained in the modules algorithms and data structures as well as Databases and software architecture

Content, progress and pedagogy of the module

Disclaimer.
This is an English translation of the module. In case of discrepancy between the translation and the Danish version, the Danish version of the module is valid.

Learning objectives

Knowledge

The student must gain insight into the following topics in database systems:

• the relational model and relational algebra
• Advanced Structured Query Language (SQL)
• logical design of relational databases, including normal forms 
• physical database design, including partitioning and storage formats (row and column storage) 
• query handling and optimization, including indexing
• transactions, concurrency control and recovery

A number of possible topics that can also be covered in the course depending on the teacher's and the students' abilities and background, for example:

• relational calculus
• parallel databases
• distributed databases
• triggers and stored procedures 
• handling and integration of semi-structured data, e.g. XML or JSON, and querying these, including full-text search

Skills

• be able to explain the relational model and apply relational algebra to a data set 
• be able to create a relational database design that adheres to recognized normal forms and use this to create an effective physical database design be able to use basic and advanced SQL to create and query a database
• be able to explain an execution plan for an SQL query and assess whether the plan is effective 
• be able to explain the transaction concept and key topics within concurrency control and recovery

Competences

By using the fundamental concepts and theories that are common to most relational database systems, the student must be able to apply these to handling large data sets.

Type of instruction

Extent and expected workload

The student is expected to spend 30 hours per ECTS, which for this activity means 150 hours.

Exam

Exams

Name of exam	Database Systems
Type of exam	Written or oral exam
ECTS	5
Permitted aids	Aids (if any) will be posted on the course page in MOODLE
Assessment	7-point grading scale
Type of grading	Internal examination
Criteria of assessment	The criteria of assessment are stated in the Examination Policies and Procedures

Additional information