Databases

5 ECTS credits
145 h study time

Offer 1 with catalog number 4019814ENR for all students in the 2nd semester at a (E) Master - advanced level.

Semester

2nd semester

Enrollment based on exam contract

Impossible

Grading method

Grading (scale from 0 to 20)

Can retake in second session

Yes

Taught in

English

Faculty

Faculty of Sciences and Bioengineering Sciences

Department

Computer Science

Educational team

Bas Ketsman (course titular)

Activities and contact hours

26 contact hours Lecture
13 contact hours Seminar, Exercises or Practicals
48 contact hours Independent or External Form of Study

Course Content

The course consists of the following topics:
- Entity-Relationship model (E-R model)
- Relational model and relational algebra
- Relational database design
- Structured Query Language (SQL)
- Transaction management
- Concurrency control
- Storage and access structures
- Alternative data models

Course material

Digital course material (Required) : Relevant material (including the lecture slides), lecture slides, contact information, deadlines, exercises, exam details etc., Canvas
Handbook (Recommended) : Database System Concepts, Silberschatz, Korth and Sudarshan, 7de, McGraw-Hill, 9781260084504, 2019

Additional info

The lectures are given in English. Relevant course material (slides) is available on the learning platform. For specific course topics, pointers to relevant additional resources (research papers, books and book chapters, website, specifications, online tutorials etc.) will be provided as well.

Additional information (such as schedules, teaching assistants, contact information, deadlines, assignments, exam detail etc.) might be found on the learning platform.

Learning Outcomes

Algemene competenties

Knowledge and Understanding:
The student is required to understand fundamental database concepts. After the course, the attendee should know about the basic concepts and techniques of conceptual modelling and database design. The student has to be able to explain the basic components of a database, the relation between them as well as the methods for manipulating persistent data. Furthermore, they can give an overview of the different parts of a database management system (e.g. query processor, storage manager etc.) and they understand the functionality of these different components.

Application of Knowledge and Understanding:
The student is able to use the presented modelling approaches and can apply them in designing specific data models for concrete examples. They are further required to know how to access and manipulate data stored in a database via a specific query language (e.g. SQL). The student can also apply other parts of the theory (e.g. transaction management) to given examples.

Judgement Shaping:
The student can identify and evaluate different parts of a database management system as well as compare different solutions for persistent data storage.

Communication:
The course attendee is able to express themselves in written and oral form about the subjects mentioned above.

This course contributes to the following programme outcomes of the Master in Applied Computer Sciences:

MA_A: Knowledge-oriented Competence

1. The Master in Engineering Sciences has in-depth knowledge and understanding of exact sciences with the specificity of their application to engineering.

3. The Master in Engineering Sciences has in-depth knowledge and understanding of the advanced methods and theories to schematise and model complex problems or processes.

MA_C: Specific Competence

18. The Master in Applied Computer Sciences is able to design and use systems for efficient storage, access and distribution of digital information.

19. The Master in Applied Computer Sciences has knowledge of and is able to use advanced processing methods and tools for the analysis of (big) data in different application domains.

23. The Master in Applied Computer Sciences is aware of data privacy and security aspects.

Grading

The final grade is composed based on the following categories:
Written Exam determines 100% of the final mark.

Within the Written Exam category, the following assignments need to be completed:

Written closed book exam with a relative weight of 100 which comprises 100% of the final mark.

Note: Written closed book examination (containing exercise/practical questions as well as theory questions)

Additional info regarding evaluation

Written closed book examination (containing exercise/practical questions as well as theory questions).

Allowed unsatisfactory mark

The supplementary Teaching and Examination Regulations of your faculty stipulate whether an allowed unsatisfactory mark for this programme unit is permitted.

Academic context