www.sum-it.nl > Courses
> DB Design course > Method > 2. Logical Design > Make ERD		Previous Previous Next Next
Nederlands · Search...

Make an ERD

Having completed the normalisation into the third normal form it is now very easy to create an ERD (also known as: Entity Relationship Diagram, entity model, logical database design, UML conceptual model, data model or Bachman diagram) with 4 tables:
An ERD with four entities: Area, Reader, Newspaper and subscription
Make an ERD.
  1. Each row of sticky pads will be a table.
  2. Use one sheet of paper per table.
  3. Add small sticky pads with data elements.
  4. Always draw one-to-many relation from top to bottom.
The tables at the bottom usually have data on the core business, which is subscription in this case. Usually these are the largest tables too, with most rows. 		Introduction 1. Scope
2. Logical Design
Normalisation steps UNF FNF SNF TNF
Make ERD
Test 3. Technical Optimisation 4. Implementation End
Next: Test