Question

What type of relationship in the conceptual model is converted to an entity in the logical database design?...


What type of relationship in the conceptual model is converted to an entity in the logical database design?

Answer

Conceptual ERD models the business objects that should exist in a system and the relationships between them.

What type of relationship in the conceptual model is converted to an entity in the logical database design?

Answer:

Conceptual ERD models the business objects that should exist in a system and the relationships between them. A conceptual model is developed to present an overall picture of the system by recognizing the business objects involved. It defines what entities exist, NOT which tables.

A Conceptual Data Model is an organized view of database concepts and their relationships. The purpose of creating a conceptual data model is to establish entities, their attributes and relationships. In this data modeling level, there is hardly any detail available on the actual database structure.

A logical data model establishes the structure of data elements and the relationships among them. It is independent of the physical database that details how the data will be implemented. The logical data model serves as a blueprint for used data. The logical data model takes the elements of conceptual data modeling a step further by adding more information to them.

A logical data model has three main components: Entities: Each entity represents a set of things, persons, or concepts relevant to a business. 

Relationships: Every relationship represents an association between two of the above entities.

Attributes: Each attribute is a descriptive piece, characteristic or any other information that is useful to further describe an entity

Recent Questions