Databases
Relational databases: ER diagrams, relational model, SQL, schema design, normalization, functional dependencies, concurrency.
Learning objectives
The 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.
Assessment
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.
Teaching methods
Lectures, exercise/practicum classes and individual homework.
Literature
Database Systems, The Complete Book, by: Hector Garcia-Molina & Jeffrey D. Ullman & Jennifer Widom. 2nd edition.
Help us improve this page
Databases
This course doesn't have detailed student info yet. Your tips, summaries, or resources would help everyone. You can submit materials anonymously — no account needed.
Submit materials
Upload summaries, notes & more
Or get in touch
Email us for quick changes, questions, or anything that isn't a large file.
Tip: Use the Canvas Course Downloader extension to export your course materials from Canvas, then upload the files through the form above.
You can also contribute via a GitHub pull request. Contributors are credited if desired.