CSC 316 Database Design CA 2026
About this paper
CSC 316: Test 1 for CSC316 Database Design, Department of Computer Science, Faculty of Science, University of Buea, 5 May 2026 (Instructors: Achankeng I., Tabo D.). Section A: relational-model concepts (relation, attribute, domain, tuple, intension/extension, degree/cardinality), the two principal integrity rules (entity and referential integrity), and views versus base relations. Section B: an Enhanced Entity-Relationship (EER) modelling exercise for a Hospital Management System, with a full EER diagram (Person generalization into Patient/Staff, Staff specialization into Doctor/Nurse/Administrative Staff, Ward-Patient and Doctor-Patient relationships), identification of multi-valued/single-valued attributes and an associative/weak entity, the conceptual-vs-logical-vs-physical modelling level, and relational databases versus big data.
Opens this paper in the app on your phone.
University of Buea
Faculty of Science - FS
Computer Science - CSC
Database Design
CA · Second Semester · Level 300
From this paper
- 1.
Discuss each of the following concepts in the context of the relational data model, demonstrating with examples: (a) Relation (b) Attribute (c) Domain (d) Tuple (row) (e) Intension and extension (f) Degree and cardinality (8 marks)
- 2.
Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules. (4 marks)
At a glance
- Course code
- CSC316 (CSC 316)
- Type
- CA
- Year
- 2026
- Level
- Level 300
- Semester
- Second Semester
- Proposed solution
- Included
Where it's from
University
University of BueaFaculty
Faculty of Science - FSDepartment
Computer Science - CSC
Read CSC316 2026 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
Don't have the app yet?