Pittsburgh PA 15147 122199 12435678 2134 Jones 224 4615 Forbes Ave Pittsburgh

Pittsburgh pa 15147 122199 12435678 2134 jones 224

This preview shows page 1 - 2 out of 2 pages.

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
Image of page 1
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.
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Spring '18
  • 王海鹏
  • Database normalization, Normal Form

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture