CSC 310 Database Design Exam 2022

About this paper

A Second Semester 2021/2022 end-of-semester examination for CSC 310 Database Design at the University of Buea Faculty of Science, dated Thursday 16/06/2022, instructed by Nyanga B. and Tabo D. Section A is a 35-item multiple-choice question covering normalization, functional dependencies, locking and concurrency control, ER modelling, SQL, transaction isolation, entities and relationships, and relational-algebra operators (division). Later sections cover foreign keys versus referential integrity, the ACID properties of transactions versus single update statements, deriving business rules from a Publisher/Book/Author/Contract ER diagram, and relational completeness plus SQL/relational-algebra query writing. A handwritten name and phone number squeezed into the venue field were excluded as incidental personal information.