CSC 310 Database Design Exam 2025

About this paper

CSC 310: Second Semester Examination, University of Buea, Faculty of Science, Department of Computer Science, Course CSC310 Database Design, Instructors Dr. Achankeng P. and Mme. Tabo D., FRI 03/07/2025. Section A (35 marks): fill-in-the-blank ER-model vocabulary; 10 Yes/No justification questions on primary/foreign keys, composite and multivalued attributes, DDL, SORT BY vs ORDER BY, GROUP BY, normal forms, and outer joins; a full ER-diagram design (Crow's Foot notation) and relational schema derivation for a regional bus transport agency; True/False analysis of an Enhanced ER (EER) diagram with an ISA hierarchy (Student/Graduate/Undergraduate, disjoint specialization); and SQL query writing against a Nobel Prize winners table. Section B (35 marks): 29 multiple-choice questions (numbered 1-29, then jumping to 31 and 32 as in the original source, which has no question 30) covering relational model fundamentals, keys, normal forms, functional dependencies, and relational algebra operations, plus a step-by-step normalization essay question using an EmployeeProject table.