Introduction to Database Management Systems

Midterm: (Time: 10:00 - 11:20, February 26th (Thursday); Location: TBA)

This is a closed book exam. However, you are allowed to bring one piece of letter sized and double sided notes to the exam.

Topics:

• Relational Model
• Database Design and ER Modelling
• SQL DDL and SQL Update queries
• Relational Algebra
• Datalog
• SQL

Study materials:

• Week 1 to Week 6 (inclusive)
• Labs 1 to 5.
• Assignments 1 to 5.

Sample past exams:

• Midterm of 2019 and its sample solution
• Midterm of 2018 and its sample solution
• Final exam of 2009 and its sample solution
• Final exam of 2023