Question $2(6$ points$)$

Describe $($use good table layout format$/$style like those used in the lecture slides, i$.$e$.$ Word table format$)$ at least $3$ tables $($with some attributes$)$ that might

be used to store information in a Car Dealership system.

Question $3(10$ points$)$

Consider the database schema below:

Notes: We use a simplified schema where we assume customer names are unique. Just in this schema.

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, accountanumber$)$

a$)$ What are the appropriate primary keys? $(6$ points$)$

b$)$ Given your choice of primary keys, identify appropriate foreign keys. $(4$ points$)$

Question $4(6$ points$)$

Using the database above, give an expression in the relational algebra for each of the following queries:

a$)$ Find all loan numbers with a loan value greater than $$10,000.$

b$)$ Find the names of all depositors who have an account with a value greater than $$6,000.$

c$)$ Find the names of all depositors who have an account with a value greater than $$6,000$ at the "Uptown" branch.