Advanced level 2026 South West mock computer science 3

Here are the questions and business rules extracted from the SECTION A: DATABASE task:

---

Scenario Overview

A clinic requires a database system to manage patient appointments with doctors.

• Specialization: Each doctor specializes in a specific medical field.

• Appointments: Patients may book appointments with different doctors on different dates.

• Date Format: $mm-dd-yyyy$.

---

Business Rules

• A patient can have multiple appointments.

• A doctor can see multiple patients.

• Each appointment is for one patient with one doctor at a specific date and time.

• No two appointments for the same doctor at the same date and time.

---

Task 1: Database Design (5 marks)

(i) Complete the entity-relationship diagram below by drawing the appropriate relationship lines and clearly indicating the cardinalities between the entities. (2 marks)

---

Sample Data (Table 1)

For your reference in answering the tasks, the data table includes the following fields:

• Patient Details: PatientID, PatientName, PatientPhone

• Doctor Details: DoctorID, DoctorName, Specialization

• Appointment Details: AppointmentDate, AppointmentTime

Would you like me to help you identify the primary keys or explain how to draw the cardinalities for the ER diagram?