Database Systems

2021/2022

Prerequisite/Recommended prerequisite for participation in the module

The module builds on knowledge gained in the module Algorithms and Data Structures

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

Name of examDatabase Systems
Type of exam
Written or oral exam
ECTS5
Assessment7-point grading scale
Type of gradingInternal examination
Criteria of assessmentThe criteria of assessment are stated in the Examination Policies and Procedures

Additional information

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

Facts about the module

Danish titleDatabasesystemer
Module codeDSNSWCB514
Module typeCourse
Duration1 semester
SemesterAutumn
ECTS5
Language of instructionDanish
Empty-place SchemeYes
Location of the lectureCampus Copenhagen
Responsible for the module

Organisation

Study BoardStudy Board of Computer Science
DepartmentDepartment of Computer Science
FacultyTechnical Faculty of IT and Design