1 votes 1 votes Consider the following relation and instance of relation: Supply(sid,Sname) #sid is key Parts(pid,Pname,Pcolor) #pid is the key Catalog(sid,pid) #sid,pid is the key Number of tuples returned by the above Query is ……... Databases databases relational-algebra made-easy-test-series + – Na462 asked Dec 2, 2018 retagged Nov 25, 2023 by Hira Thakur Na462 670 views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply Hemanth_13 commented Dec 2, 2018 reply Follow Share 6? 0 votes 0 votes Na462 commented Dec 2, 2018 reply Follow Share Mine was 6 too but its 0 0 votes 0 votes Hemanth_13 commented Dec 2, 2018 reply Follow Share I think 100,null on comparing with 100,5 will return false in SQL but not sure in RA. Maybe we have treat it the same here as well 0 votes 0 votes Please log in or register to add a comment.
3 votes 3 votes Answer is 0. Bcoz no violet color in parts table. (In cross product if any one of the table contains 0 record then no tuples will be selected.) ARUN KUMAR 3 answered Dec 3, 2018 ARUN KUMAR 3 comment Share Follow See all 3 Comments See all 3 3 Comments reply bhargav1 commented Jan 28, 2019 reply Follow Share According to truthtable of subtraction A B A-B 0 0 0 0 1 1 1 0 1 1 1 0 So,we will get 6 values. 0 votes 0 votes gauravkc commented Jan 28, 2019 reply Follow Share what method is this? Can u explain? 0 votes 0 votes Psy Duck commented Nov 15, 2022 reply Follow Share @bhargav1 Dont post whatever u want 0 votes 0 votes Please log in or register to add a comment.