Consider the bank database schema shown below (see the textual description below). Assume that branch names uniquely identify branches. Also assume that loans and accounts can be associated with more than one customer. Format: tableName ( attributes ) 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. You must include a picture/illustration of your relational database schema diagram in your PDF submission
) Consider the bank
Assume that branch names uniquely identify branches. Also assume that loans and
accounts can be associated with more than one customer.
Format:
tableName ( attributes )
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. You must include a picture/illustration of your relational database schema
diagram in your PDF submission
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images