1. Explain the steps in the process of putting a relation straight into Boyce-Codd Normal Form (BCNF). 2. Convert the fo
Posted: Tue Nov 16, 2021 9:03 am
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