Entity Relationship Diagram Example: Car Insurance

Description:

Entity relationship diagrams (ERD) are widely used in database design and systems analysis to represent systems or problem domains. This ERD example shows the entities involved in a car insurance system. It consists of person, car and accident.

Use this ERD template to get started building your own. Customize the ERD to reflect the entities of your problem. Click Use this Template to start.

What is Entity Relationship Diagram?

Entity relationship diagrams (ERD) are widely used in database design and systems analysis to represent systems or problem domains. An ER diagram is a pictorial representation of the information that can be captured by a database. It allows database professionals to describe an overall data model of a system concisely yet accurately and can be easily transformed into the relational schema. The ERD is an implementation-independent representation of a problem domain and it facilitates communication between the end-user and the analyst.

Conceptual Design vs Logical Design vs Physical Design ERD

Conceptual Design - Creating an Entity Relationship Diagram (ERD) and associated data dictionary to represent the reality and capture business data requirements

Logical Design - Transforming ERD to relational model: tables, keys (constraints), etc.

Physical Design - Creating the database and other supporting structures based on a specific DBMS

Keen to try VP Online?

No limitations, no obligations, no cancellation fees.


Start a Free Trial