Cloud Database Development and Management

Database Development and Management with SQL  ◾  123

CREATE TABLE SHIPPING

(

ShippingID INT PRIMARY KEY,

OrderID INT NOT NULL,

EmployeeID INT NOT NULL,

ShippingDate DATETIME NOT NULL,

Street VARCHAR(50) NOT NULL,

City VARCHAR(50) NOT NULL,

State VARCHAR(50) 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)

)

ere are two intersection tables in the Computer_Store database, ORDER_INVENTORY

and CUSTOMER_PAYMENT. ese two tables contain multiple foreign key columns that are

also used in ...