Discussion

Week 4 Discussion 1

Denormalization Functionality

The textbook identifies normal forms beyond 3NF. Please respond to the following in not more than 250 words:

Demonstrate, in a realistic scenario, how data consumers benefit from denormalized tables. Do not repeat an example from the textbook or one that has been posted by another student.

Then, in separate posts, follow up to one or more of your fellow students in substantive posts of up to 200 words that further the discussion. For example, you may support or politely challenge a post with your own insights or experience, make a suggestion, or ask probing follow-up questions.

Support your ideas with explanations and/or sources, as appropriate.

Week 4 Discussion 2

Optimizing Database Design

Legacy database systems can have hundreds of tables with millions of rows. These may be only partially normalized. Please respond to the following in not more than 200 words:

What is one specific procedure you could perform to locate either an unnormalized or an extraneous table? Do not repeat an example from the textbook or one that has been posted by another student.

Then, in separate posts, follow up to one or more of your fellow students in substantive posts of up to 150 words that further the discussion. For example, you may support or politely challenge a post with your own insights or experience, make a suggestion, or ask probing follow-up questions.

Support your ideas with explanations and/or sources, as appropriate.