Databases Question | Excelling Homework

Q1
The following figure present BANK ER diagram. Map it into a full relational schema. Specify all primary keys and foreign keys.
Q2
Write appropriate SQL DDL statements to define the database schema you made in the previous question. Create all the appropriate Referential Integrity constrains.
Q3
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)
Q4
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}