Explain denormalization, and why it may be appropriate to denormalize a set of tables
What will be an ideal response?
Denormalization is the process of taking a normalized set of relations and converting them into a smaller set of relations that is in a lower normal form and thus vulnerable to a greater number of anomalies. While the fully normalized set of relations is more desirable from a theoretical perspective, it does have some disadvantages. The greater the number of relations in the database, the more work that is required by the database whenever data must be retrieved from multiple relations to reconstruct the users' view of the data. In some circumstances, the anomalies introduced by denormalizing a data model may be considered an acceptable cost for the performance improvement from reducing the overhead work performed by the database.
You might also like to view...
Which visual support is a real-life example of your subject?
? A) a diagram B) an object C) a graph D) a model
The relative performance metric can be created by ________
A) dividing the performance rating of a product by the average performance rating of all products in the market B) dividing the overall rating of a product's performance by the rating of the top-performing brand C) dividing the overall rating of a product's performance by its price D) dividing the overall rating of a product's performance by the average price for products in that product category E) dividing the overall rating of a product's performance by the cost of manufacturing the product