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 _____
- $\pi_{customer-name} (\sigma_{balance > 10000^{(Deposit)}}$)
- $\sigma_{customer-name} (\sigma_{balance > 10000^{(Deposit)}}$)
- $\pi_{customer-name} (\sigma_{balance > 10000^{(Borrow)}}$)
- $\sigma_{customer-name} (\pi_{balance > 10000^{(Borrow)}}$)