Question: Question 32 2 Points Consider the following table which shows information about Doctors. Patients. Clinic, and Appointments, all in one table. DocPatientAppointments Table DrID DrName

 Question 32 2 Points Consider the following table which shows information
about Doctors. Patients. Clinic, and Appointments, all in one table. DocPatientAppointments Table
DrID DrName DrRank D18 John Smith Senior PatID P70 POS P93 POS

Question 32 2 Points Consider the following table which shows information about Doctors. Patients. Clinic, and Appointments, all in one table. DocPatientAppointments Table DrID DrName DrRank D18 John Smith Senior PatID P70 POS P93 POS P81 Ahmed Nasir D59 PatAge CID 12 C1 35 C2 7 (3 35 C2 62 @3 Pat Name Abdulla Ali Qasim Ahmed Fatima Sami Qasim Ahmed Sameer Omar Prof CIBlock 1044 904 350 904 350 AppDate 15-Jan-17 16-Jan-17 15-Jan-17 18-Jan-17 20-Jan-17 identify all functional dependencies in the above table. Use the editor to format your answer Question 33 1 Point Refer to the table in 0.32 which is in UNF. What shall you do to make it in 1NF using table flattening. Explain Use me editor to format your answer Question 34 2 Points Refer to 0.33 If the outcome of 0.33 is already in 2NF explain why, If not, do make it in 2NF. (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 answer Question 35 2 Points Refer to 0.34 of the tables produced in Q-34 are already in 3NF explain why. If not, do make them in 3N5 (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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!