MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
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. | pcustomer-name (sbalance u003e 10000(Deposit) |
| B. | scustomer-name (sbalance u003e 10000(Deposit) |
| C. | pcustomer-name (sbalance u003e 10000(Borrow) |
| D. | scustomer-name (pbalance u003e 10000(Borrow) |
| Answer» B. scustomer-name (sbalance u003e 10000(Deposit) | |