Data Mining and Warehousing

profilenewman
 (Not rated)
 (Not rated)
Chat

Data Mining and Warehousing

 

Unit 2 Discussion Board

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?

 

  • 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?
    • 10 years ago
    Data Mining and Warehousing
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      data_mining_and_warehousing.doc