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).

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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.

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Use Code FREE15