Pittsburgh, PA1514712/21/99124356782134Jones2244615 Forbes Ave,Pittsburgh, PA1514712/25/99213456781.List the primary key. 2.List all the FDs. 3.List all the update anomalies and provide an example of each. 4.What normal form is the relation in? Explain. 5.Apply normalization to it incrementally, bringing the relation to 3NF. That is, ifthe relation is unnormalized, bring it to first normal form, then bring the firstnormal form you've just created to second normal form, and then bring thesecond normal form to third normal form. For each transformation to the next higher normal form X, oExplain the steps you took to bring it to the normal form X. oProvide the normal form X's table structure, primary key(s), and theFDs. oExplain why you think it is in the normal form X. That is, if the relation were in an unnormalized form, you would explain the
transformation you performed to bring it to first, second, and third normal forms. You would also provide the table structure, the primary key, and the FDs for the first, second, and third normal forms. You would also provide explanation for why you believe it is in first, second, and third normal forms.
You've reached the end of your free preview.
Want to read both pages?
- Spring '18
- Database normalization, Normal Form