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 Databases tbb-dbms-1 numerical-answers + – Bikram asked Nov 26, 2016 • edited Aug 21, 2019 by go_editor Bikram 755 views answer comment Share Follow See all 17 Comments See all 17 17 Comments reply Show 14 previous comments Bikram commented Jul 18, 2017 reply Follow Share @ Shubhanshu Conclusion 2 1:M relation b) total at 1's side only Then number of table would be 2 and conclusion 3 you made same table, need to check here .. You can read this thread https://gateoverflow.in/123659/self-doubt 0 votes 0 votes Shubhanshu commented Jul 19, 2017 reply Follow Share @Bikram sir, it is about the self-referential relation. but I am talking about the non self-referential relation. 1 votes 1 votes Ashwani Kumar 2 commented Oct 2, 2019 reply Follow Share Dealer has $20$ tuples and cars have $60$ tuples. Since it is mentioned that dealer owns one or more cars that means we can't leave any dealer to have car. Moreover each car is owned by at most one dealer. For maximum tuples each 20 tuple of dealer associated with 20 tuple of dealer. Left with 40 more tuple of cars, we can associate each one of them by any of dealer as dealer can have one or more car. Total = 20+40 = 60 tuples 0 votes 0 votes Please log in or register to add a comment.
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. Bikram answered Jul 15, 2017 • selected Aug 21, 2019 by Bikram Bikram comment Share Follow See all 2 Comments See all 2 2 Comments reply hem chandra joshi commented Dec 26, 2017 reply Follow Share I think if we do full outer join than we get max(m,n) rows. 0 votes 0 votes ChandanKumar123 commented Apr 13, 2019 i edited by ChandanKumar123 Oct 29, 2019 reply Follow Share "Each dealer owns one or more cars and each car is owned by at-most one dealer." Let each dealer take 3 diff cars so owns table will have 3*20(as participation is total)=60 tuples. participation is 1's at dealers and many at cars side i.e pk of car will be pk of owns. minimum tuples will also be 60. 0 votes 0 votes Please log in or register to add a comment.