The requirements shown in Question 11 have changed. The dentist’s office would like to add the date of the patient’s last payment. In which relation (table) would you place this attribute? Why?

Data From 11

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