You are about to design a database for a new bank based on the ER- Diagram provided, you are…

You are about to design a database for a new bank based on the ER- Diagram provided, you are required to do the following:

a) Map the ER-Diagram into a relational schema.

(Show links between PKs and FKs).

b)Write DDL / SQL commands to create all the relations in the schema.

c)Write DML commands that insert at least 2 records in each table.

d) Write a DML command that updates any value in any record you have added (only one DML is enough).

e) [1 Point] Write a DML Command that deletes one customer from the bank.

f) Write the following Select Statements:

1. Retrieve the customer name and the type of the loan.

2. Retrieve the customer name, social security number and account type.

3. Retrieve the account information along with the branch no and the branch address.

Attachments:

Looking for a similar assignment? Get help from our qualified experts!

"Our Prices Start at $9.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Order a Similar Paper Order a Different Paper