Entity Relationship Model

An Entity Relationship (ER) model is used to design a database.
An ER Diagram is drawn to visualize the database.
The ER Diagram contains Entities, Relationships, and Attributes.
  description examples database part ER diagram symbol
entity The "noun":
An object with a distinct set of attributes.
The building blocks of the database.
student

course

grade
table a rectangle
attribute The "adjective":
A property of an entity that makes it different from other entities — information about the entity.
student id

student name

course id
field an ellipse
relationship The "verb":
The association between entities.
"studies":
The relationship between student and course.

"marries":
The relationship between two persons.
key a diamond

Simple ER Diagram

simple ER diagram