MIS407-Module 5 Critical thinking:

I have updated my ERD Diagram, added some more attributes to it due to the course requirement:

Considering the above updated diagram can you show me how to create :

1) DDL SQL statement for the Customer table, Order Table, Line_Item table & Product table.

2) DML SQL statements for the Customer table, Order Table, Line_Item table & Product table.

3) SQL Select statements for the above.

Thank you for your help :)

Customer Product Customer ID First Name LastName BillingAddress ShippingAddress PhoneNumber ProductID LineltemID ProductDis ProductType UnitPricee Stockquantity Places Added To Order Line_Item OrderID CustomerlD OrderDate Total Amount of Order LineltemID OrderID Quantity Price Size ShippingQuantity ShippingDate