Question
Database textbooks and tutorials emphasize the need to ensure normalization of the database. While database designers and database administrators will generally ensure that their databases
Database textbooks and tutorials emphasize the need to ensure normalization of the database. While database designers and database administrators will generally ensure that their databases follow best practices relative to normalization, many production databases in use today have ignored normalization. Some people will argue that a de-normalized production database reflects poor design, while others will argue that good database architects will knowingly deploy a de-normalized database under the right circumstances. After completing the textbook reading and performing some research on the topic of database normalization, discuss your thoughts on the topic of deploying a de-normalized database versus a normalized database. Under what circumstances, if any, do you consider it reasonable to deploy a de-normalized database? To what extent will your final project’s database be normalized and why?
Specifically, address the following critical elements:
1. Define, analyze, and compare a de-normalized database and a normalized database.
2. Define the circumstances under which you consider it reasonable to deploy a de-normalized database, or explain why you feel it is not reasonable to do so.
3. Explain the extent to which your final project’s database will be normalized and why.
Step by Step Solution
3.38 Rating (145 Votes )
There are 3 Steps involved in it
Step: 1
1 Denormalized databases posses great redundancy and organization of data is poor in the denormalize...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started