Your supervisor has approved your normalized versions of the database. Your team members were given copies. One of the members has sent you an e-mail with the following questions:

  • Why are there so many more foreign keys in the third normal form than in the first? Is this always going to be true?
  • Why is it important to define the primary keys of a file correctly? What happens to the third normal form when they are incorrectly defined?
  • Some designers will say that to make an address file into third normal form, you should take out the city and state, place it into a different table, and link it by zip code. What advantages and disadvantages are there to this?
  • When normalizing a table that can have a many-to-many relationship with another table, what steps should you take?
  • What are the advantages of third normal form for applications with a lot of changes to the database, such as a data entry program?
  • What are the disadvantages of third normal form for an application that does a lot of reporting on a stable database like general ledger month-end reporting?
Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.