1.Only Partial participations-
- One-One:2 Tables, Merge Relation to any of the side.
- Many-One or One-Many:2 Tables, Merge Relation to Many side.
- Many-Many:3 tables (separate table for relation)
2. Any one of the side has full participation-
- Full participation on Many Side: 2 Tables
- Full Participation on one side: 1 Table
3.Both Side full participation-
- Always one table irrespective of Cardinality.