Cardinality and associations

May 6, 2008 at 1:18 PM

Anybody has given it already a thought on how to implement one-to-one, one-to-many and many-to-many relationships? Is using the SQL Server Extended Properties a good suggestion? For example, I can decorate the child table with a custom property called 'UserParentTable' and refer to the parent table. If I apply an unique index on the child table, then I assume one-to-one.

Any thoughts?