Create the following database and tables in SQL.

 

CUSTOMER CustomerID FirstName Last Name Phone Street City State Zip CUSTOMER_PAYMENT PaymentID (FK) CustomerID (FK) Payment Date PAYMENT Payment ID Payment Type ORDERS OrderID CustomerID OrderDate ORDER INVENTORY OrderID (FK) InventoryID (FK) Quantity Figure 4.1 Computer_Store data model. SHIPPING ShippingID ShippingDate OrderID Employee D Street City State Zip PRODUCT ProductID ProductName INVENTORY InventoryID ItemID (FK) QOH Price EMPLOYEE EmployeeID FirstName LastName ITEM ItemID ProductID (FK) CPU RAM Hard Drive Optical Drive Monitor