Q56,Paper3 ,D13. Consider the following schemas :

Branch = (Branch-name, Assets, Branch-city)

Customer = (Customer-name, Bank name, Customer-city)

Borrow = (Branch-name, loan number, customer account-number)

Deposit = (Branch-name, Account-number, Customer-name, Balance)

Using relational Algebra, the Query that finds customers who have balance more than 10,000 is _______

(A) πcustomer-name(σbalance > 10000(Deposit)

(B) σcustomer-name(σbalance > 10000(Deposit)

(C) πcustomer-name(σbalance > 10000(Borrow)

(D) σcustomer-name(πbalance > 10000(Borrow)

^{Answer A.}

^Explanation.

Balance attribute is in table Deposit  so only A,B. and it is asking for projection of customer name hence option A.