Banking Database Schema: branch ( branch_name, branch_city, assets ) customer ( cust_ID, customer_name, customer_street, customer_city ) loan ( loan_number, branch_name, amount ) borrower ( cust_ID, loan_number ) account ( account_number, branch_name, balance ) depositor ( cust_ID, account_number ) a) What are the appropriate primary keys? Indicate the appropriate primary keys by copying-and-pasting the above schema and underlining the primary key attributes. b. Given your choice of primary keys, identify appropriate foreign keys (i.e. identify attributes in referencing and referenced relations). You can state the foreign key constraints in words. For example, “For loan relation: branch_name attribute referencing branch relation.” c. Construct a relational database schema diagram for the bank database given above. Include a picture/illustration of your relational database schema diagram
Banking
branch ( branch_name, branch_city, assets )
customer ( cust_ID, customer_name, customer_street, customer_city )
loan ( loan_number, branch_name, amount )
borrower ( cust_ID, loan_number )
account ( account_number, branch_name, balance )
depositor ( cust_ID, account_number )
a) What are the appropriate primary keys? Indicate the appropriate primary keys by copying-and-pasting the above schema and underlining the primary key attributes.
b. Given your choice of primary keys, identify appropriate foreign keys (i.e. identify attributes in referencing and referenced relations). You can state the foreign key constraints in words. For example, “For loan relation: branch_name attribute referencing branch relation.”
c. Construct a relational database schema diagram for the bank database given above. Include a picture/illustration of your relational database schema diagram
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images