Example: see click here
can store N^{3} tuples (= information items)
can only store 3 × N^{2} tuples (= information items)
That is because:
I.e.: we must store the following tuples:
(s1, p1, pj1) (s1, p2, pj2) (s2, p1, pj2) (s2, p2, pj1)
The possibilities are as follows:
We will get the following tuples:
(s1, s1-addr, s1-phone, p1, {pj1, pj2} ) (s2, s2-addr, s2-phone, p2, {pj1, pj2} )
Or the following tuples:
(s1, s1-addr, s1-phone, {p1, p2}, pj1 ) (s2, s2-addr, s2-phone, {p1, p2}, pj2 )
Both solutions have one multi-valued attribute and is unacceptable
(p1, p1-addr, p1-phone, s1, {pj1, pj2} ) (p2, p2-addr, p2-phone, s2, {pj1, pj2} )
(p1, p1-addr, p1-phone, {s1, s2}, pj1 ) (p2, p2-addr, p2-phone, {s1, s2}, pj2 )
Again, both solutions have one multi-valued attribute and is unacceptable
(pj1, pj1-addr, pj1-phone, s1, {p1, p2} ) (pj2, pj2-addr, pj2-phone, s2, {p1, p2} )
(pj1, pj1-addr, pj1-phone, {s1, s2}, p1 ) (pj2, pj2-addr, pj2-phone, {s1, s2}, p2 )
Yet again, both solutions have one multi-valued attribute and is unacceptable
Example: to represent the ternary relationship
Create this relation (table): Supply( sname, pname, pjname ) Sample content: (s1, p1, pj1) (s1, p2, pj2) (s2, p1, pj2) (s2, p2, pj1)