CEF 300 Information Systems CA 2023

About this paper

CEF 300: Continuous Assessment Test (2 hours, 20 marks; source carries no institution letterhead, date or instructor name), University of Buea: Exercise 1, designing a detailed ER model for a Ministry of Transport supplies-tracking scenario (buildings, rooms, items, departments, employees with a recursive supervision relationship); Exercise 2, a given university course/session/student/lecturer ER diagram with questions on conceptual-vs-logical modeling, relationship/entity classification, a relational schema derivation, and one SQL CREATE TABLE statement.