Question $1.[13$ MARKs$]$

Consider the following schema for a hair salon.

Relations

Clients$()$ name, phone$).$

CID is the ID of a client, name and phone are their name and phone number.

Staff$($SID$,$ name$).$

SID is the ID of a staff member and name is their name.

Appointments$($CID$,$ date, time, service, SID$)$

CID is the ID of the client whose appointment it is$,$ date and time indicate when the appointment

happens, service is the name of the service they have at this appointment, and SID is the ID of the

staff member providing the service for this apppointment.

Integrity Constraints

Appointments$[$CID$]$ sube Clients$[$CID$].$

Appointments$[$SID$]$ sube Staff$[$SID$].$

Recall that no nulls are permitted in the relational model.

Part $($a$)[5$ MARKS$]$

Create an ER diagram that represents this data well.