Normalization

Consider the relation PATIENT, which contains information about patients of a family dentist.$$ Each patient belongs to a household.$$ One patient may receive multiple services.

$$

PATIENT $\{$HoseholdNum$,$ HouseHoldName, Street, City, State, Zip, Balance, PatientNum, PatientName, ServiceCode, Description, Fee, Date$\}$

$$

Suppose that the following functional dependencies hold on PATIENT:

FD$1$: PatientNum $$ HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance,

$$ PatientName

FD$2$: HouseholdNum $$ HouseHoldName, Street, City, State, Zip, Balance

FD$3$: ServiceCode $$ Description, Fee

FD$4$: PatientNum, ServiceCode $$ Date

FD$3$: ServiceCode $$ Description, Fee

FD$4$: PatientNum, ServiceCode $$ Date