Computer Science · May / June 2025 · Paper 2 TZ2 HL · Question 1

1. Alpha Hospital is situated in a large city and has over 1000 staff. It stores its data in a relational database. Some of the tables in this relational database contain data about the hospital staff, their roles, and the hospital departments. Staff roles include doctor, nurse, pharmacist, radiologist, and support staff. Staff can only hold one role. Departments include Accident and Emergency, Critical Care, Medical, General Surgery, Orthopaedics, and Ophthalmology. Staff can work in several departments. The ROLE table, STAFF table, and DEPARTMENT table are shown in Figure 1. Figure 1: Diagrammatic relationship for the ROLE table, STAFF table and DEPARTMENT table ROLE STAFF DEPARTMENT RoleID StaffID DepartmentID PayGrade RoleID ManagerID DepartmentID Building FirstName Surname DateOfBirth

Read automatically from the paper; the printed page above is exact.