Question: (a) Draw a schema diagram for this this database schema. [15 points] Branch (branch name, branch city, assets) customer (customer name, customer_street, customer city) loan

(a) Draw a schema diagram for this this database schema. [15 points] Branch (branch name, branch city, assets) customer (customer name, customer_street, customer city) loan loan number, branch name, amount) borrower (customer name, loan number) account (account number, branch name, balance) depositor (customer name account number) (b) Considering the schema above, write relational expressions for following sentences [12 points] i. Find all loan numbers with a loan value greater than $10,000. ii. Find the names of all depositors who have an account with a value greater than $6,000. ii. Find the names of all depositors who have an account with a value greater than $6,000 at the "Uptown" branch
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
