Show every step of your normalization process for credit

(1) Normalize the following table into 3-rd NF:

T(x, y, z, w)

Here x-->y,y -->z

(2)Convert the following table to an equivalent collection of tables that is 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, Zip, Balance, PatientNum, PatientName, ServiceCode, Description, Fee, Date)

(The following dependencies exist in the Patient table)

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

HouseholdNum HouseholdName, Street, City, State Zip, Balance

ServiceCode Description, Fee

PatientNum, ServiceCode Date

(3) The following exercises are based on the Premiere Products database. Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. Part (PartNum, Description, OnHand, Class, Warehouse, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice) )

Customer

OrderLine

Orders

Parts

Reps

Switchboard Items

1. (10 pts) Normalize the following table into 3-rd NF: T(x. y, z, w) Here xy,yz 1. (10 pts) Normalize the following table into 3-rd NF: T(x. y, z, w) Here xy,yz