Question: Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist.

Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household. 

Patient (HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientNum, PatientName, (ServiceCode, Description, Fee, Date))

The following dependencies exist in the Patient table:

PatientNum → HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientName HouseholdNum → HouseholdName, Street, City, State, PostalCode, Balance ServiceCode → Description, Fee PatientNum, ServiceCode → Date

Step by Step Solution

3.49 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Patient PatientNum HouseholdNum PatientNa... View full answer

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

Document Format (2 attachments)

PDF file Icon

1807_60b8c1214487b_716269.pdf

180 KBs PDF File

Word file Icon

1807_60b8c1214487b_716269.docx

120 KBs Word File

Students Have Also Explored These Related Database Concepts Questions!