Wednesday, 13 July 2011

Patterns in a database

  • One to many:   use of foreign key
  • Many to Many: Mapping table
  • Super-type subtype Relationship:Generalization
  • Reflexive pattern(hierarchy pattern):Self join type pattern