Microsoft Access Question

Normalizing a Patient Relation

Consider the following relation:

Patient(Patient#, PatientName, BalanceDue, DentistID, DentistName, ServiceCode, ServiceDesc, ServiceFee, ServiceDate)

This is a relation concerning data about patients of dentists at a dental clinic and services the dentists perform for their patients. The following dependencies exist in Patient:

Patient# --> PatientName, BalanceDue, DentistID, DentitstName

DentistID --> DentistName

ServiceCode --> ServiceDesc, ServiceFee

Patient#, DentistID, ServiceCode --> ServiceDate

1. Convert Patient to 1NF based on the functional dependecies given.

2. Convert to a set of relations in 3NF.

3. The database desing needs to include an attribute for the date of the patient's last visit. In what table would you place this attribute?