Introduction to Database Management Systems

Final Exam: (Time: 13:00 - 16:00, 17 April 2025, Thursday; Location: Gym)

Final Review

Topics:

• Relational Model
• Database Design and ER Modelling
• Relational Algebra
• Datalog
• SQL (Data Definition, Data Retrieval and Update)
• Database Application Programs
• Functional Dependency and Normal Forms
• Transaction Management and Concurrency Control
• Database Recovery
• Database Storage Model and Indexing
• Database Security, Views, and Constraints

Study materials:

• All Lectures
• Labs 1 to A. (Some are not posted yet.)
• Assignments 1 to A. (Some are not posted yet.)

Sample past exams:

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

Midterm: (Time: 13:00 - 14:20, February 27th (Thursday); Location: Building 250/Room 125)

Topics:

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

Study materials:

• Lectures up to February 27th
• Labs 0 to 5.
• Assignments 1 to 6.