Last answered:

01 Nov 2021

Posted on:

26 Oct 2021


Resolved: Understanding Relationship Types

I don't understand the diagram in Relationship.
Customer to Sales: It's one to many. So the symbol used near Sales table is >|.
But From Sales to Customer, it is many to one but why are we writing the symbol as || ???

2 answers ( 1 marked as helpful)
Posted on:

27 Oct 2021


he supposes that the sales can't take more than one customer. it's an example, not more.
you are right, it can be many to one (more than customer buy one sale) .like Customer to Sales
> | means  |  minimum  one .... >  maxium many
|| means        | minimum one   | and max is one too (to achieve one to many relation)

Posted on:

01 Nov 2021


Hi Moe and Mahmoud!

Thanks for reaching out.

@Mahmoud: Thank you very much for providing this clarification!

Please let us know if you need further assistance. Thank you.

Submit an answer