CEF 342 DATABASE AND DESIGN Exam 2023

About this paper

CEF 342: End of Semester Exam, University of Buea, Department of Computer Engineering: Question 1, naming/explaining the three data-redundancy anomalies (insertion, update, deletion) with examples from a given denormalized construction-company reporting table; Question 2, defining a trigger with a non-SQL example; Question 3, a full Crow's Foot ERD design exercise for Automata Inc.'s purchasing system (entities, relationships/connectivities, existence dependence, sample reports, and the diagram with cardinalities, optionalities, resolved M:N relationships and foreign keys); Question 4, deriving the relational schema and dependency diagram for a denormalized STUDENT table, identifying determinants and transitive dependencies, and decomposing it to 3NF; Question 5 (Bonus), SQL queries (a LIKE-pattern name search, and a multi-table join/report) against given Employee, Job and Project tables.