Databases Question | Excelling Homework

The following figure present BANK ER diagram. Map it into a full relational schema. Specify all primary keys and foreign keys.
Write appropriate SQL DDL statements to define the database schema you made in the previous question. Create all the appropriate Referential Integrity constrains.
Using DML SQL, write the appropriate SQL query for each of the following:
Insert A new customer with the following information:
Delete all the loans for customer with SSN: 2222
Select all customer who got loans more than 250000 SAR, print the customers SSN, name
Print all the Accounts in Bank: ALBILAD and in branch no: 5
(Name: Ali, SSN: 1111, Address: Riyadh, Phone: 05555)
Draw the ER-Diagram for the following database schema. Specify the types of relationships in details on the diagram.
Customers{Customer_ID, C_Name}
Employees {Employee_ID, E_Name}
Orders{ Order_No, Customer_ID , Employee_ID,}
Order_Details {Order_No, Product_No}
Products{Product_NO, Product_Name}

Don't use plagiarized sources. Get Your Custom Essay on
Databases Question | Excelling Homework
For $10/Page 0nly
Order Essay

Calculate the price of your paper

Total price:$26

Need a better grade?
We've got you covered.

Order your paper