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

(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

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