Assignment #5 Show every step of your normalization process for credit I. (10 pts) Normalize the following table into 3-rd NF: T(x, y, z, w) Here xy, yz 2. (20 pts)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. (50 pt) 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 formm. Part (PartNum, Description, OnHand, Class, Warehouse, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice))