30 Pts Normalize Following Tables 3 Rd Nf R X Y Z X Y Y Z T X Y Z W X Y Z W Q X Y Z X Y X Q37083072

1. (30 pts) Normalize each of the following tables into 3-rdNF:

• R(x, y, z)     Here xày,    yàz

• T(x, y, z, w)     Herexày,    z à w

• Q(x, y, z)         Herex à y, xà z

2. (20 pts)Convert the following table to an equivalent collectionof tables that are in third normal form. This table containsinformation about patients of a dentist. Each patient belongs to ahousehold.

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

The following dependencies exist inthe Patient table:

PatientNum à HouseholdNum,HouseholdName, Street, City, State, Zip, Balance, PatientName

HouseholdNum à HouseholdName, Street,City, State Zip, Balance

ServiceCode à Description,

OR

 

OR