Advanced level 2026 BAEBOC computer science 3

Here are the specific questions and business requirements extracted from the TASK 1: DATABASE MANAGEMENT SYSTEM assessment:

---

Scenario Overview

The Cameroon National Social Insurance Fund is computerizing its records.

• Employee Attributes: social_insurance_number, full_name, gender, date_of_birth, marital_status, job_title, monthly_salary, and the branch.

• Branch Attributes: branch_code, branch_name, location, and manager.

• Insurance Scheme Attributes: scheme_code, scheme_name, and monthly_deduction_rate.

Tracking Goals:

• Which employee is registered to which insurance scheme(s)?

• How much is deducted for each scheme?

• What total amount is deducted from each employee per month?

---

Task 1: Conceptual Design

i) Identify and list the main entities in the above scenario. (2 marks)

ii) Draw an Entity Relationship (ER) diagram showing all entities, Primary keys, Relationships, and indicating their cardinalities. (5 marks)

---

Task 2: Implementation (SQL)

Using any DBMS of your choice, write the SQL statements to:

i) Create the database Social Insurance. (1 mark)

ii) Create the tables based on your ER diagram. Include appropriate data types and primary/foreign keys.

---

Would you like me to help you identify the entities and primary keys, or would you like the SQL code to create these tables?