Intro to Entity-Relationship Model
Explore the entity-relationship model to understand how entities and relationships represent data in databases. This lesson uses a company database example to illustrate ER diagram concepts and prepares you to design clear data schemas.
We'll cover the following...
We'll cover the following...
The entity-relationship data model
The entity-relationship (ER) data model is a high-level conceptual data model that has existed for over 35 years. It is well suited to data modeling for use with databases because it is fairly abstract and is easy to discuss and explain. ER models, also called ER schemas, are represented by ER diagrams.
ER modeling is based on two concepts: ...