Post No. #937
- A one-to-one relationship means both columns contain unique values. This cardinality type isn't common, and it likely represents a suboptimal model design because of the storage of redundant data.
-The one-to-many and many-to-one cardinality options are essentially the same, and they're also the most common cardinality types.When configuring a one-to-many or many-to-one relationship, you'll choose the one that matches the order in which you related the columns.
- A many-to-many relationship means both columns can contain duplicate values. This cardinality type is infrequently used.
- A one-to-one relationship means both columns contain unique values. This cardinality type isn't common, and it likely represents a suboptimal model design because of the storage of redundant data.
-The one-to-many and many-to-one cardinality options are essentially the same, and they're also the most common cardinality types.When configuring a one-to-many or many-to-one relationship, you'll choose the one that matches the order in which you related the columns.
- A many-to-many relationship means both columns can contain duplicate values. This cardinality type is infrequently used.