Data base management system

1. Explain the steps in the process of putting a relation straight into Boyce-Codd Normal Form (BCNF). 2. Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household. Here is the information about the Patient table: Patient (HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientNum, PatientName, (ServiceCode, Description, Fee, Date)) The following dependencies exist in the Patient table: PatientNum HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientName HouseholdNum HouseholdName, Street, City, State, PostalCode, Balance ServiceCode Description, Fee PatientNum, ServiceCode Date - - 2. Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household. Here is the information about the Patient table: Patient (HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientNum, PatientName, (ServiceCode, Description, Fee, Date)) The following dependencies exist in the Patient table: PatientNum HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientName HouseholdNum HouseholdName, Street, City, State, PostalCode, Balance ServiceCode Description, Fee PatientNum, ServiceCode Date