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
Patient PatientNum HouseholdNum PatientNa... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1807_60b8c1214487b_716269.pdf
180 KBs PDF File
1807_60b8c1214487b_716269.docx
120 KBs Word File
