Question: Question One ( 2 Marks Consider the bank database. [0.5+0.5+1=2 Marks] branch(branch name, branch city, assets) customer (customer name, customer street, customer city) nal write

 Question One ( 2 Marks Consider the bank database. [0.5+0.5+1=2 Marks]

Question One ( 2 Marks Consider the bank database. [0.5+0.5+1=2 Marks] branch(branch name, branch city, assets) customer (customer name, customer street, customer city) nal write loan (loan number, branch name, amount) borrower (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number) Give an expression in the relational algebra for each of the following queries: a. Find all loan numbers with a loan value greater than $50,000. b. Find the names of all depositors who have an account with a value greater than $9,000. c. Find the names of all depositors who have an account with a value greater than $8,000 at the "Uptown" branch

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To express these queries in relational algebra lets break them down a Find all loan numbers with a l... View full answer

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 Databases Questions!