which entities(in given question) could  make  M:M  relationship

noor haya
noor haya used Ask the Experts™
on
I had this question after viewing Normalization to 3NF; shopping cart data.which entities(in given question) could  make  M:M  relationship
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
nociSoftware Engineer
Distinguished Expert 2018

Commented:
Can you describe how a N:M relationship is implemented?...
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
I don't see an Order details table in your design, if it is available, then you can have M:M relationship between Order details and Products like one order can have Multiple products or one product across multiple orders making it a M:M relationship..
Without Order details table, I guess you can have 1:M relationships only..
nociSoftware Engineer
Distinguished Expert 2018

Commented:
N:M relations are already given away: the Cart f.e.   User & Products in the cart. Users can have many products, Products can have many users.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial