ISYS1055/1057 | Database Concepts | Database

Question 1. The Relational model (10 marks).

A spreadsheet was used to keep data for the booking system of the ABC Clinic, with sample data shown in Table 1. Columns 1-4 contain information for doctors, Columns 5-9 contain information for patients and the last 3 columns contain information for patient’s appointments with doctors. The spreadsheet for the table is also available on Canvas.

ISYS1055-1057 - Database Concepts - Database-1

ISYS1055-1057 - Database Concepts - Database-2

ISYS1055-1057 - Database Concepts - Database-3

ISYS1055-1057 - Database Concepts - Database-4

 

Solution