Picturing the relation from sales to customers table we could say it is a many to one relationship, that being the case why was the cardinality mentioned as || near the customers table though? Could you please illustrate with an example?

Hi Meenakshi! Thanks for reaching out. The first symbol which is from left to right next to the customers table is the minimum number of instances of the sales table that can be associated with the customers table. The second symbol is the maximum number of instances of the sales table that can be associated with the customers table. So, this is the reason why we have || next to the customers table. Hope this helps. Best, Tsvetelin

Follow this topic

Meenakshi Akila P.S

Last answered:

16 Dec 2021

Posted on:

05 Nov 2021

Regarding cardinality symbol used in the relational schema

in SQL / Relationships

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Posted on:

16 Dec 2021

Regarding cardinality symbol used in the relational schema

Submit an answer

related questions