cus 1165 Project Assignments Fall 2018 [Compatibility Mode] a- Search in Document Home Insert Design Layout References Mailings Review View Share ^ , Arial Paste Styles Pane Heading 1 No Specing EmphasisIntece Emp. Assignment #6 Normalization -Appointments and Pron Submit: a properly normalized ERD in class standard ERD format. A) for the Appointments DB Current incorrect (not properly normalized) Appointments ERD APPOINTNENT PK App Num DOCTOR App Date App_Time pp PatienD App Name App Phone App Sreet App City App State App Zp App Status PK Doc FEmplD Doc Frame Dos CellPhone Doc EmpID: Empleyee ID Tor the doctor DocFname: Do or's first name. Doc Lname: Decter's last name. Doc_CellPhone: Declor's cell phone numbei. - App Num: System-generated number. App Date: The date of the appointment. App_Time: The time of the appointment App_PatienlD: The id aumber ef the patient. App ame: The name of the patient App Phone: The contact phone namber of the patient. App Street: The street address for the patient App City: The dty the patient lives in. App State: The state Eie patient lives in. App Zip: The zip code fer the patient's addiess. App_Status: The status of the appointment pending, dosed, cancelled) Page 3 of9 1459 WordsEnglish (uS) R, E - 128%