Solve the following, according to the previous Database:

$1.$ Create the Entity $-$ Relationship Diagram & Schema Diagram using ERDPlus$(3$pts$).$

$2.$ Create the Database Tables $(3$pts$).$

a$.$ Order

b$.$ Payment

c$.$ Customer

d$.$ Address

e$.$ Order$\_$datails

f$.$ Menu

$3.$ Define Relationships between tables $(2$pts$).$

$4.$ Fill the $6$ tables with $5$ records for each.$(3$pts$)$

$5.$ Write SQL queries to: $(4$pts$)$

a$.$ To Display the order details $($Order$\_$id$,$ Menu$\_$id$,$ Order$\_$Quantity and

total$\_$price$)$ from the Order$\_$details table for orders whose total price is more

than $200.$

b$.$ To Display customer details $($Customer$\_$ID$,$ Customer$\_$Name$)$ and payment

details $($Total$\_$Amount, Payment$\_$DateTime, Payment$\_$method$)$ from

Customers and Payment tables for all customers with the Name $$Omer$.$

c$.$ To display the menu details $($Menu$\_$id and Menu$\_$Price$)$ from the Menu table

for menus with menu price more than $300$ or menu price less than $1000.$

d$.$ To Display the order details and menu details from the Menu and

Order$\_$Details tables.

e$.$ To display details of orderss and addresses from the orders and addresses

tables for all orders for the city of $$Jenin