Cloud Database Development and Management

128  ◾  Cloud Database Development and Management

)

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