CA2024Proposed solution included

CSC 310 Database Design CA 2024

About this paper

A 30-minute 'Design Test 1' for CSC 310 Database Design at the University of Buea Faculty of Science, academic year 2024/2025, instructed by Dr Achankeng P. and Mme Tabo D. Question 1 asks Yes/No justification questions on ER modelling concepts (logical vs conceptual models, composite primary keys, unary relationships, associative entities, weak entities). Question 2 asks for a Crow's-foot ER model of a Library Management System covering books, authors, members, staff, book copies, borrowing and fines. Question 3 asks True/False questions about an Enhanced ER diagram with a PERSON superclass specializing disjointly into EMPLOYEE and STUDENT, with further specializations. A handwritten name and phone number in the header were excluded as incidental personal information.

Open in Shoracy

Opens this paper in the app on your phone.

University of Buea

Faculty of Science - FS

Computer Science - CSC

CSC3102024

Database Design

CA · Second Semester · Level 300

Open in the app to read the full paper and its proposed solution.

View solutionOpen in Shoracy
Proposed solution included

At a glance

Course code
CSC310 (CSC 310)
Type
CA
Year
2024
Level
Level 300
Semester
Second Semester
Proposed solution
Included

Where it's from

  1. University

    University of Buea
  2. Faculty

    Faculty of Science - FS
  3. Department

    Computer Science - CSC

Read CSC310 2024 in Shoracy.

  • Every page, with zoom for diagrams and small print
  • The proposed solution, one tap away
  • Stays on your phone after the first open, even offline
Open in Shoracy