Database Development and Management with SQL - Cloud Database Development and Management - page 128

)
GO
CREATE TABLE INVENTORY
(
InventoryID INT PRIMARY KEY,
ItemID INT,
Qoh INT DEFAULT 0 CHECK(Qoh >= 0) NOT NULL,
Price MONEY DEFAULT 0 CHECK (Price >= 0) NOT NULL,
CONSTRAINT Inventory_ItemId_fk
FOREIGN KEY (ItemID)
REFERENCES ITEM (ItemID)
)
GO
CREATE TABLE ORDERS
(
OrderID INT PRIMARY KEY,
CustomerID INT NOT NULL,
OrderDate DATETIME NOT NULL,
CONSTRAINT Orders_CustomerId_fk
FOREIGN KEY (CustomerID)
REFERENCES CUSTOMER (CustomerID)
)
GO
CREATE TABLE SHIPPING
(
ShippingID INT PRIMARY KEY,
OrderID INT NOT NULL,
EmployeeID INT NOT NULL,
ShippingDate DATETIME NOT NULL,
Street VARCHAR(30) NOT NULL,
City VARCHAR(30) NOT NULL,
State VARCHAR(30) NOT NULL,
Zip CHAR(5) NOT NULL,
CONSTRAINT Shipping_OrderId_fk
FOREIGN KEY (OrderID)
REFERENCES ORDERS (OrderID),
CONSTRAINT Shipping_EmployeeId_fk
FOREIGN KEY (EmployeeID)
REFERENCES EMPLOYEE (EmployeeID)
)
GO
CREATE TABLE ORDER_INVENTORY
(
OrderID INT,
InventoryID INT,
Quantity INT DEFAULT 0 CHECK(Quantity >= 0) NOT NULL,
CONSTRAINT OInventory_OrderID_fk