Buy Answer Now 2277

Posted: December 15th, 2023

Q1)he 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:
a) Insert A new customer with the following information:
(Name: Ali, SSN: 1111, Address: Riyadh, Phone: 05555)
b) Delete all the loans for customer with SSN: 2222
c) Select all customer who got loans more than 250000 SAR, print the customers SSN, name
d) Print all the Accounts in Bank: ALBILAD and in branch no: 5Q4)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}