351 views
0 votes
0 votes

1 Answer

1 votes
1 votes
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

Related questions

0 votes
0 votes
1 answer
1
Ashutosh_17 asked Mar 30, 2023
788 views
Let R be a relation of degree 5 then the total number of projections possible on R is ___?
0 votes
0 votes
0 answers
4
aashijn asked Apr 28, 2022
1,331 views
employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name) a. Find the names of all empl...