CREATE TABLE Orders
(
OrderID NUMBER NOT NULL,
CustomerID CHAR(5),
EmployeeID NUMBER,
OrderDate DATE,
RequiredDate DATE,
ShippedDate DATE,
Freight NUMBER,
ShipName VARCHAR2(40),
ShipAddress VARCHAR2(60),
ShipCity VARCHAR2(15),
ShipRegion VARCHAR2(15),
ShipPostalCode VARCHAR2(10),
ShipCountry VARCHAR2(15),
CONSTRAINT PK_Orders
PRIMARY KEY (OrderID),
CONSTRAINT FK_Orders_Customers FOREIGN KEY (CustomerID)REFERENCES Customers(CustomerID),
CONSTRAINT FK_Orders_Employees FOREIGN KEY (EmployeeID)REFERENCES Employees(EmployeeID)
)
/ I have provided SQL code to create all tables andinsert all data. There is an error in setting referentialintegrity: one of the tables is missing references. Read the codeand identify the problem. You can either modify create tablestatement or add alter table statement to include missingreferences.
Expert Answer
An answer will be send to you shortly. . . . .