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?
Paper#79123 | Written in 18-Jul-2015Price : $22