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] 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
To express these queries in relational algebra lets break them down a Find all loan numbers with a l... View full answer
Get step-by-step solutions from verified subject matter experts
