CODEWITHSUNDEEP
database-designentity-relationship
Mohammod Shihab Hossain
Mohammod Shihab Hossain

Reputation: 1

In ER diagram, is order and cart relationship are weak entity relationship?

In an entity relationship (ER) diagram, is the relationship between Order and Cart considered a weak entity relationship? Because order depends on the cart.

I analyzed the relationship between Order and Cart in an ER diagram. I expected it to be a weak entity relationship due to potential dependency on a primary key. However, I am unsure if this interpretation is correct.

Upvotes: -1

Views: 37

Answers (1)

LRJ
LRJ

Reputation: 26

No. It would be a weak entity relation if the order only depends on cart. But the order does not primarily depend on the cart and is independent which means the order exists without cart. A weak entity relationship would require the Order to be fully dependent on the Cart for its identification, which is not the case here.

Upvotes: 1

Related Questions