https://studiegids.vu.nl/en/courses/2025-2026/X_401008The students will learn:to design and evaluate database schemas using Entity-Relationship diagrams, (Applying knowledge and understanding) (Making judgements)to understand the relational model (including integrity constraints such as key constraints and foreign key constraints), (Knowledge and understanding)to translate Entity-Relationship diagrams into relational schemas (and to enforce cardinality constraints by design), (Applying knowledge and understanding)to reason about good and bad database design using functional dependencies, (Making judgements)to apply normalization algorithms to transform a database schema into (various) normal forms, (Applying knowledge and understanding)to understand concurrency concepts like transactions, schedules and concurrency anomalies, and (Knowledge and understanding)to reason about different techniques for concurrency control (lock based concurrency control, optimistic concurrency control, multiversion concurrency control). (Making judgements)The course is concerned with base principles and important aspects of relational databases. The course objective is to obtain a good knowledge and understanding of relational database systems. This includes the ability to develop good database models, and to query and update databases using SQL.Lectures, exercise/practicum classes and individual homework.The homework is mandatory for qualifying for the exam (70% of the homework points to qualify for the exam). In the case that at least 90% of the homework points are obtained, 0.5 bonus points are awarded for the final grade. At the end of the course, there is a final exam. The overall grade is the grade of the final exam plus the possibly 0.5 bonus point obtained for the homework. (The bonus is only added for students who pass the exam with a grade of at least 5.5.) There is no resit opportunity for the homework.Database Systems, The Complete Book, by: Hector Garcia-Molina & Jeffrey D. Ullman & Jennifer Widom. 2nd edition.Bachelor Artificial Intelligence (year 2)Bachelor Business Analytics (year 2) Bachelor Computer Science (year 2)Basic programming skills help.