Which of the following is NOT a possible process in denormalization?
A)Include a parent entity's attributes in its child entry on the physical data model
B)Look carefully at relationships to see which entities are frequently accessed together
C)Rewarding abnormal actions with more processing MIPS
D)Develop look-up tables that include the description along with the code
E)Use a star schema design to imitate a multidimensional database

Question

Quizplus · Accepted Answer

Denormalization involves simplifying database structures to improve query performance by reducing the number of joins needed. It usually involves combining data from multiple tables into a single table or duplicating data to avoid costly joins. However, rewarding abnormal actions with more processing MIPS is not a process in denormalization, as it involves using hardware resources to compensate for inefficient coding practices rather than optimizing the database design.

Which of the Following Is NOT a Possible Process in Denormalization