Question: branch ( branch _ name, branch _ city, assets ) customer ( ID , customer _ name, customer _ street, customer, city ) loan (

branch(branch_name, branch_city, assets)
customer(ID, customer_name, customer_street, customer, city)
loan(loan_number, branch_name, amount)
borrower(ID, loan_number)
account(account_number, branch_name, balance)
depositor(ID, account_number)
Give an expression in relational algebra for each of the following queries.
a. Find each loan number with a loan amount greater than $10000.
b. Find the ID of each depositor who has an account with a balance greater than $6000.
c. Find the ID of each depositor who has an account with a balance greater than $6000 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!