How to create ERDs and databases

1. List all entities
2. Find Relationships [E-R matrix]
3. Draw Cardinality
4. Define Primary keys
5. Draw ERD
6. Eliminate many-to-many relationships
7. Identify attributes [attribute entity matrix]
8. Map attributes - only 1:1 with each entity
9. Draw final ERD