Question: Database systems 4. (20 POINTS) Consider a bank database given as follows: branch(bName, bCity, assets) customer(cName, street, city) loan(loanNo, bName, amount) borrow(cName, loanNo) account(accountNo, bName,
Database systems

4. (20 POINTS) Consider a bank database given as follows: branch(bName, bCity, assets) customer(cName, street, city) loan(loanNo, bName, amount) borrow(cName, loanNo) account(accountNo, bName, balance) deposit(cName, accountNo) Write the corresponding relational algebra expression for the following queries: 4.A.) (10 POINTS) List the names of depositing customers whose account balance is more than $10,000. 4.B.) (10 POINTS) List the names of depositing customers whose account balance is more than S10,000 at the "Richardson" branch
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
