Create the following database and tables in SQL. CUSTOMER CustomerID FirstName Last Name Phone Street City State

Create the following database and tables in SQL.

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

To create the database and tables in the diagram you provided we can use the following SQL statements Create the database CREATE DATABASE computerstor... View the full answer