edited by
673 views
0 votes
0 votes

Each dealer owns one or more cars and each car is owned by at-most one dealer. If Dealer table has $20$ tuples and Cars table has $60$ tuples then owns table can have maximum _____ number of tuples

edited by

1 Answer

Best answer
1 votes
1 votes
There is total participation from Dealer entity .

Partial participation from Car entity .

Each car have at least and at most one dealer , there are 60 tuples for Car table , so that Owns table  must have 60 tuples at maximum.
selected by
Answer:

Related questions

0 votes
0 votes
1 answer
1
Bikram asked Nov 26, 2016
384 views
Let the search key field of a B+ tree is 4 Bytes , the disk block size is 199 Bytes , and the index pointer is 3 Bytes, then the order of B+ tree is _______
1 votes
1 votes
1 answer
3
Bikram asked Nov 26, 2016
319 views
Consider the join of relation R with a relation S. If R has $m$ tuples and S has $n$ tuples, then the maximum and minimum sizes of the join, respectively, are __________....
0 votes
0 votes
1 answer
4
Bikram asked Nov 26, 2016
229 views
A functional dependency of the form x → y is trivial ify ⊆ xy ⊂ xx ⊆ yx ⊂ y