List directly-related entity type pairs.
Write the business rules to determine cardinality. Draw the ERD.
Designate primary keys (PKs) and foreign keys (FKs).
Identify other needed attributes.
Review ERD participation and constraints and update the ERD. Document: Data Modeling Example Bottom Up Database Design Approach (PDF).
