The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:
A) referential integrity.
B) normalization.
C) denormalization.
D) data warehousing.
E) online analytic processing.

Question

Quizplus · Accepted Answer

The process of transforming a logical data model into a physical model that is efficient for the most often used tasks is called denormalization. This involves adding redundant data and creating fewer tables to optimize query performance. Referential integrity and normalization are important steps in creating a logical data model, while data warehousing and online analytic processing are related topics but not directly relevant to the transformation of a logical model into a physical one.

The Process of Taking a Logical Data Model and Transforming