details.appName
CSC310 (CSC 310) - Database Design - 2025 Exam - University of Buea
- 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.
