The starting point of the physical database design process is ____.
A) the creation of indexes over the relational tables
B) the output of the logical database design process
C) the denormalized tables
D) the unnormalized data
E) the set of entities, attributes, and relationships

Question

Quizplus · Accepted Answer

The physical database design process is based on the output of the logical database design process, which includes the entity-relationship diagram, the functional dependencies, and the normalization level of the data. The physical design process involves translating the logical design into a physical schema, optimizing performance with indexing and clustering, defining security and user access levels, and choosing the appropriate storage and backup options. The denormalized tables and unnormalized data are not recommended starting points for the physical design process, as they may lead to redundancy, inconsistency, and poor performance. The creation of indexes is part of the physical design process, but it is not the starting point.

The Starting Point of the Physical Database Design Process Is