CSC 310 Database Design Exam 2025

About this paper

CSC 310: Second Semester Examination for CSC310, Database Design, Department of Computer Science, Faculty of Science, University of Buea, Friday 27 June 2025 sitting (2024/2025 academic year). Students answer ALL questions in both sections. Section A Question 1 is a fill-in-the-blank section on the Entity-Relationship model, covering static visualization models, single-valued attributes, weak-entity identifying relationships, derived attributes, key attributes, candidate/primary keys, and normalization to avoid insertion/deletion/update anomalies. Section A Question 2 is a yes/no justification section covering relational database implementation, ACID transaction support, composite primary keys, database schema sub-components, derived-attribute notation (double ovals), primary/foreign key duplication rules, SQL DDL commands, and the SORT BY/GROUP BY clauses.