Data Modeling - One-to-One Relationship (bijection)

1 - About

A one-to-one relationship describe that one row from a dataset point to exactly one row to the other dataset.

There are three way to model a one-to-one relationship:

  • either the associated entities share the same primary keys values,
  • a foreign key is held by one of the entities. This FK column should be constrained unique to simulate one-to-one multiplicity),
  • or an association table is used to store the link between the 2 entities. A unique constraint has to be defined on each FK to ensure the one to one multiplicity.

2 - Article related

  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at del.icio.us
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Digg
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Ask
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Google
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at StumbleUpon
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Technorati
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Live Bookmarks
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Yahoo! Myweb
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Facebook
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Yahoo! Bookmarks
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at Twitter
  • Bookmark "Data Modeling - One-to-One Relationship (bijection)" at myAOL
data_modeling/one-to-one.txt ยท Last modified: 2012/12/26 22:09 by gerardnico