Note: Please use proper referencing (where necessaryl when submitting your report. Report without references shall not be acceptable. If you do not have software for drawing ERD, you can draw on paper by hand and take picture and include that in your report. Do not forget to write your name and ld on the paper on which you hand draw ERD 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 Hum FK1 Doc_Empid DOCTOR Ar Die Apr Time PK Doc. Emaio As Patient ApeNa Doc Frame Ape Phone Doe Lame Are Street Dee ColPhone ARCHY Are State Ape Zip Dre_Emplo Emplayset for the actos. App Status Das Frame: Doctor's first name. Dec lname ocher last sume. Duc_Cell Phones Doctor's cell phone number App Store App Date: The date of the appointment App. Thine: The me the appointment App Patientit. The number of the patient. Apy Name The name of the patient. App Phong The compounder of potent App Sweet The hot the patient App hy the city the lives in App State: The state the patient lives in. App : The road to the paint's des App Status: The main of the appointment pending, sed, cancelled