Consider the below schema of a table that describes a pet store: purchase id cust_i cust_n...

Transcribed Image Text:

Consider the below schema of a table that describes a pet store: purchase id cust_i cust_n pet nam d ame e store_na me cust_id →→ cust_name pet_name→→ pet_price pet_ price The table is in first normal form. This domain has the following functional dependencies: purchase_id, pet_name →qty purchase_id →→store_name, purchase_date, cust_id, cust_name purchase _date C. a. Convert the above table into a set of tables in second normal form. Your answer should be the schemas of the resulting tables. qty b. Continue to normalize this database by converting your answer in (a) to a set of tables in third normal form. Your answer should be the schemas of the resulting tables. Give an example of a form of data duplication that would be eliminated by the above process. Consider the below schema of a table that describes a pet store: purchase id cust_i cust_n pet nam d ame e store_na me cust_id →→ cust_name pet_name→→ pet_price pet_ price The table is in first normal form. This domain has the following functional dependencies: purchase_id, pet_name →qty purchase_id →→store_name, purchase_date, cust_id, cust_name purchase _date C. a. Convert the above table into a set of tables in second normal form. Your answer should be the schemas of the resulting tables. qty b. Continue to normalize this database by converting your answer in (a) to a set of tables in third normal form. Your answer should be the schemas of the resulting tables. Give an example of a form of data duplication that would be eliminated by the above process.

Answer rating: 100% (QA)

Lets go through the normalization process step by step a Convert the table into second normal form 2NF Second normal form requires that the table be i... View the full answer