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}

Get your paper done on time by an expert in your field.
plagiarism free

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: