118k views
2 votes
Transiting from Conceptual/Logical to Physical ERD

A) Conceptual ERD is used for implementation, while Physical ERD focuses on high-level design.
B) Conceptual ERD represents business concepts, while Physical ERD models database tables.
C) Conceptual ERD is more detailed than Physical ERD.
D) Physical ERD is used for system requirements, while Conceptual ERD is for user perspectives.

1 Answer

3 votes

Final answer:

The correct statement is option B, which states that Conceptual ERD represents business concepts, while Physical ERD models database tables. Conceptual ERD is high-level and generalized, while the Physical ERD is detailed and specific.

The right answer is B) Conceptual ERD represents business concepts, while Physical ERD models database tables.

Step-by-step explanation:

When transitioning from Conceptual/Logical to Physical Entity-Relationship Diagrams (ERDs), it's important to understand the differences between these models.

A Conceptual ERD is focused on representing business concepts and outlines high-level business structures and relationships, without concern for how the data will actually be implemented in a database, thus it lacks the detailed specifications of database constraints, indexes, and other physical attributes.

In contrast, a Physical ERD is focused on modeling the actual structure of the database, which includes detailed tables, columns, data types, constraints, and relationships that will be physically implemented in the database management system.

To clarify the options given by the student, only option B is correct: Conceptual ERD represents business concepts, while Physical ERD models database tables.

Conceptual ERD is high-level and generalized, whereas Physical ERD is specific and detailed, used for the actual implementation of the database structure.

The right answer is B) Conceptual ERD represents business concepts, while Physical ERD models database tables.

User Eugene Zhulenev
by
8.5k points