Question: branch ( branch _ name, branch _ city, assets ) customer ( ID , customer _ name, customer _ street, customer, city ) loan (
branchbranchname, branchcity, assets
customerID customername, customerstreet, customer, city
loanloannumber, branchname, amount
borrowerID loannumber
accountaccountnumber, branchname, balance
depositorID accountnumber
Give an expression in relational algebra for each of the following queries.
a Find each loan number with a loan amount greater than $
b Find the ID of each depositor who has an account with a balance greater than $
c Find the ID of each depositor who has an account with a balance greater than $ at the "Uptown" branch.
Please explain steps to arrive at answer.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
