Answer Happy

Question No. 1 (Marks 8) Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure given below into a dependency diagram that is in at least 3NF. Draw diagram for every level going from 1NF to 2NF to 3NF. Please give reasoning for any selection (at all levels) that you make. Providing only dependency diagram is not enough. APPOINTMENT PK App Num FK1 Doc_EmpID App Date App Time App Patient D App Name App Phone App Street App_City App State App Zip App Status App Num: System generated number. App Date: The date of the appointment. Page 1 of 2 DOCTOR 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. PK Doc EmpID Doc Fname Doc Lname Doc CellPhone 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 City: The city the patient lives in. App State: The state the patient lives in. App /ip: The zip code for the patient's address. App Status: The status of the appointment pending, closed, cancelled