6 ECTS credits
172 h study time
Offer 2 with catalog number 1007156ANR for all students in the 2nd semester at a (A) Bachelor - preliminary level.
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
Additional information (such as schedules, teaching assistants, contact information, deadlines, assignments, exam details etc.) might be found on the learning platform.
Relevant course material (slides) is available on Canvas. 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.
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.
The final grade is composed based on the following categories:
Written Exam determines 90% of the final mark.
Other Exam determines 10% of the final mark.
Within the Written Exam category, the following assignments need to be completed:
Within the Other Exam category, the following assignments need to be completed:
Written closed book examination (containing exercise/practical questions as well as theory questions). Assignments that have to be done during the semester. The final grade is a weighted average over the two partial marks.
In case of overall failure, the written exam can be redone during the second exam period. The partial mark on assignments will be transferred. The final mark is calculated in the same way as in the first exam period.
This offer is part of the following study plans:
Bachelor of Business Economics: Minor Minor Education (only offered in Dutch)
Bachelor of Geography: Default track (only offered in Dutch)
Bachelor of Computer Science: Default track (only offered in Dutch)
Bachelor of Mathematics and Data Science: Standaard traject (only offered in Dutch)
Bachelor of Artificial Intelligence: Default track (only offered in Dutch)
Master of Physics and Astronomy: Minor Economy and Business
Master of Teaching in Science and Technology: biologie (120 ECTS, Etterbeek) (only offered in Dutch)
Master of Teaching in Science and Technology: geografie (120 ECTS, Etterbeek) (only offered in Dutch)
Master of Teaching in Science and Technology: fysica (120 ECTS, Etterbeek) (only offered in Dutch)
Master of Teaching in Science and Technology: wiskunde (120 ECTS, Etterbeek) (only offered in Dutch)
Master of Teaching in Science and Technology: ingenieurswetenschappen (120 ECTS, Etterbeek) (only offered in Dutch)
Master of Teaching in Economics: standaard traject (90 ECTS, Etterbeek) (only offered in Dutch)