• Each entity has a unique ID number (primary key)
• Name, location etc.
• Key attributes
o Uniquely identifies an entity or relationship
o Identified by being underlined
• Each relationship has 3 properties
Key attribute - If unique, underline (social insurance number)
Ex: social security number
How much of one entity is related to other entity?
Write that number on top, write M for many, N= many to many
Cannot have M to M – have to have M to N
Is everyone of this particular entity is related to the other entity?
Single line represents partial participation
Double line represents total participation
Example: Faculty would be in a rectangle, is a chair of would be in a diamond, and
department would be in a rectangle
Designing an E-R Diagram:
1. Collect and review ALL the data
2. Identify entities and attributes and draw them on your ER diagram
3. Identify the key attributes and underline them on your diagram
4. Decide on the relationships and draw lines between the entities, including any
attributes of the relationships 5. Decide on the car