CODEWITHSUNDEEP
database-design
Haych
Haych

Reputation: 942

Whats the difference between a Conceptual Data Model and an ER Diagram?

I know the difference between a Conceptual Data Model and a Logical Data Model, but what is the difference between a Conceptual Data Model and an ER diagram? They look extremely similar! Is there any difference?

Upvotes: 3

Views: 7757

Answers (2)

Sara
Sara

Reputation: 29

The three types of datamodels are Conceptual model: describes data at a very high level such as the ER model

Representational model : describes the logical part of the database such ad Relational model

Physical data model :describes data storage information and is used to generate DDL statments

Upvotes: 0

Edper
Edper

Reputation: 9322

ERD (Entity-Relatinship-Diagram) is one of the method in Conceptual Data Modeling in order to flesh out in visual form the user requirements whether explicit or implicit in nature. Other method used also in Conceptual Data Modeling is the NIAM (Natural language Information Analysis Method) which is primarily used in Europe and use different symbols compared to ERD Modeling. Obviously, ERD is more popular hence the one you normally see as the modeling method in Conceptual Data Modeling level.

See this link and this link also.

Upvotes: 7

Related Questions