Recommended prerequisite for participation in the module

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 entity relationship charts (ERD)
• Structured Query Language (SQL)
• logical design of relational databases (normal forms)
• physical database design
• query management and optimization
• 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

Skills

• be able to explain the relational model and apply relational algebra to a data set
• be able to construct an ERD for smaller, concrete scenarios
• be able to create a relational database design that adheres to recognized normal forms
• be able to use 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 concept of transaction and key topics within concurrency control and recovery

Competences

Using the fundamental concepts and theories that are common to most database systems, the student must be able to use these to handle larger data sets in practice.

Type of instruction

The teaching is organized in accordance with the general teaching methods for the education § 17.

Extent and expected workload

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

Exam

Exams

Additional information

Kontakt: Studienævn for datalogi via cs-sn@cs.aau.dk eller 9940 8854