Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And SQL For DB2

Authors: James Cooper

1st Edition

1583473572, 978-1583473573

Students also viewed these Databases questions

Question

fscanf retums a special value EOF that stands for...

Answered: 1 week ago