Question

We begin the physical design phase by addressing the design of physical fields for each attribute in a ________ data model.

A) Conventional
B) Conceptual
C) Physical
D) Logical

Answer 1

In the physical design phase of database design, we address the design of physical fields for each attribute based on a logical data model, which is then translated into a detailed physical schema for actual database implementation.

Step-by-step explanation:

We begin the physical design phase by addressing the design of physical fields for each attribute in a logical data model. During the physical design phase in database design, the logical data model is translated into a physical schema, which includes the detailed specifics of how data will be stored in the database. This involves defining the physical storage, indexes, access paths, and other parameters that will make the database system operational and efficient.

After the entities and relationships have been defined in the conceptual data model and refined into the logical data model with specific attributes and data types, the next step is to map this logical data model onto a physical data model that can be implemented using a specific database management system (DBMS).