Introduction to Database Management Systems

Final Exam: (Time: April 18th, Thursday, 9am-noon Location: Building 315/Room 216)

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.
• Assignments 1 to A.

Sample past exams:

• Midterm of 2019 and its sample solution
• Midterm of 2018 and its sample solution (updated Feb. 28, 2023)
• Final exam of 2009 and its sample solution
• Final exam of 2023