0 0 votes Databases + – Deepalitrapti 749 views answer comment Share Follow Print See 1 comment 1 1 comment reply Deepanshu commented Sep 5, 2018 reply Follow flag IN C OPTION A*B HAS FOUR COLUMNS TWO OF WHICH ARE CUSTOMER NAME. AS WHEN WE CROSS PRODUCT WE HAVE ALL COLUMNS. SO WE DONT KNOW WHICH CUSTOMER NAME THEY ARE TALKING ABOUT 0 0 replyShare Please log in or register to add a comment.
1 1 vote A) option A is inner join on Borrower and Depositor on customer-name so it will give all customers which having loan and account. B) SELECT DISTINCT CUSTOMER-NAME FROM BORROWER WHERE CUSTOMER-NAME IN(SELECT CUSTOMER-NAME FROM DEPOSITOR);--> This will also return all different names of customers who taken loans. C) this is cross product of two tables so it will give many redundant tuples. so this is wrong query according to question requirements. Ans:C Dharmendra Lodhi answered Sep 5, 2018 Dharmendra Lodhi comment Share Follow See all 2 Comments 2 2 Comments reply Deepalitrapti commented Sep 5, 2018 reply Follow flag But after it perform projection in which all redundant tuple removed???? 0 0 replyShare Dharmendra Lodhi commented Sep 5, 2018 reply Follow flag after projection duplicates will remove , not redundant(extra) 0 0 replyShare Please log in or register to add a comment.
