This course provides a comprehensive introduction to database systems, starting with the fundamental concepts of Information Systems and Database Systems, and the motivation for their use.
Key topics include data modeling with the Entity-Relationship (ER) model, transitioning to the relational model, and using relational algebra for data manipulation. Students will learn the fundamentals of SQL, including data definition, manipulation, and querying.
Advanced topics cover relational design theory, addressing redundancy, normalization, and integrity constraints, as well as transaction management and security in multi-user environments.
- Teacher: Daniel Borcard
- Teacher: Marcel Bühlmann
- Teacher: Simon Curty
- Teacher: Hans-Georg Fill