CODEWITHSUNDEEP
database-design
Steven
Steven

Reputation: 149

What many-to-many relation I have to chose?

When I do have a table:

user: userID

product: productID

and a table named user_product: userID, productID

what would look like the many to many relation concerning using 1, 1..m , 0..m and so on?

Upvotes: 0

Views: 21

Answers (1)

amahfouz
amahfouz

Reputation: 2398

It depends on the application.

Is a user always associated with product? Probably not, and if so, there is a '0..infinity' on the product side of the relation.

Is a product always associated with a user? Probably yes, and if so, there should be a '1..infinity' on the user side of the relation.

Upvotes: 1

Related Questions