Why is it important to accurately map the physical model of a database?

An accurately mapped physical model is the blueprint for the database's implementation. It improves data consistency by enforcing data types, relationships, and constraints. It enhances querying by defining efficient storage structures and indexes. It also reduces data duplication by implementing a normalized design, which minimizes redundancy. Therefore, all listed options are critical benefits of an accurate physical model.

A. This is a correct statement, but it is not the only benefit. The question implies a comprehensive answer is needed.
B. This is also a correct statement, but it is only one aspect of why an accurate physical model is important.
C. This is another correct statement, but it is incomplete on its own. The best answer encompasses all benefits.

1. Oracle Corporation. (2009). Oracle Database Design Guide

11g Release 2 (11.2). Chapter 1

Introduction to Database Design

Section "Goals for the Database Design". This section outlines goals including data consistency

reduced redundancy

and performance.

2. Silberschatz

A.

Korth

H. F.

& Sudarshan

S. (2019). Database System Concepts (7th ed.). McGraw-Hill. Chapter 8

Relational Database Design

discusses how proper design (which the physical model implements) achieves these goals.