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 denormalized production database reflects poor design, while others will argue that good database architects will knowingly employ a denormalized 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 denormalized database versus a normalized database. under what circumstances, if any, do you consider it reasonable to deploy a denormalized database

Question

Lola Barrera

Computers & Technology

23 August, 18:23

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 denormalized production database reflects poor design, while others will argue that good database architects will knowingly employ a denormalized 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 denormalized database versus a normalized database. under what circumstances, if any, do you consider it reasonable to deploy a denormalized database

+2

Answers (1)

Know the Answer?

Julianna · Answer 1

I don't think is best to deploy denormalized database (expect of course its a small application that probably wouldn't have any future update). Normalized database will eliminate data reputation and allows for seamless scalability of application if properly done. Normalized bad might lead to slow database performance if not properly done.