Ire P$6\mathrm{.}1$ Appointment ERD for Problem $1$

App$\_$Num: System$-$generated number.

Doc$\_$EmpID: Employee ID for the doctor.

Doc$\_$Fname: Doctor's first name.

Doc$\_$Lname: Doctor's last name.

Doc$\_$CellPhone: Doctor's cell phone number.

App$\_$Date: The date of the appointment.

App$\_$Time: The time of the appointment.

App$\_$PatientID: The ID number of the patient.

App$\_$Name: The name of the patient.

App$\_$Phone: The contact phone number of the patient.

App$\_$Street: The street address for the patient.

App$\_$City: The city the patient lives in$.$

App$\_$State: The state the patient lives in$.$

App$\_$Zip: The zip code for the patient's address.

Case Study $4$

App$\_$Status: The status of the appointment $($pending$,$ closed, cancelled$)$