Question: 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

Consider the below schema of a table that describes a pet store: purchase id cust_i cust_n pet nam d ame e

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.

Step by Step Solution

3.50 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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 full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!