ITIS213

Database Manegment system

Question 32 2 Points Consider the following table which shows information about Doctors. Patients. Cinic and Appointments, all in one table DocPatientAppointments Table DrID Dr Name DrRank DIS John Smith Senior CI PatID P70 POS P93 POS PRI D59 Ahmed Nasir Pat Name Abdulla Ali Qasim Ahmed Fatima Sami Qasim Ahmed Sameer Omar PatAge CUID 12 35 C2 7 C3 35 C2 62 C3 CIBlock 1044 904 350 904 AppDate 15-Jan17 16-Jan-17 15.Jan.17 18-Jan-17 20 Jan 17 Prof 350 1 identity al functional dependencies in the above table use the editor to format your answer 1 Point Question 33 Refer to the table in Q.3 which is in UNE. What shall you do to make it in infusing table fattening. Explain use the enter to sormor your answer Question 34 2 Points Refer to 0.33 if the outcome or 0.33 is already in 2NF explain why, if not do make itin 26 (Hint: only write the headers of the sub tables, without data. Also identity the PK for each table produced use the color to format your answer Question 35 2 Points Refer to 0.34 if the tables produced in 0.34 are already in 3NF explain why, if not do make them in 3NE. (Hint: only write the headers of the sub tables, without data. Also identify the PK for each table produced) use the editor to format your