Consider the following schemas : Branch = (Branch-name, Assets, Branch-city)…
PYQ UGC NET 2013
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))
Attempted by 431 students.
Sign up free to check your answer
Sign up freeLoading lesson…

