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

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 and insert all data. There is an error in setting referential integrity: one of the tables is missing references. Read the code and identify the problem. You can either modify create table statement or add alter table statement to include missing references.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

CREATE TABLE Orders ( OrderID NUMBER NOT NULL, CustomerID CHAR(5), EmployeeID NUMBER, OrderDate DATE, RequiredDate DATE, ShippedDate DATE, Freight NUMBER, ShipName VARCHAR2(40), ShipAddress...

Need help with part 2 Part 2. Sorting; logical operators (and, or) 2.1 I want to get a list of customer in these cities: Berlin, Madrid, London, Bern. Order the results by city. 2.2 Get all orders...

Need help with part 3 Part 3. Simple table join 3.1 Display first and last names of ALL employees along with names of their managers. 3.2 Get the employee who processed the order 9905 (order id);...

Need help writing queries for: Part 1. Projection and Selection 1.1 Please get all data in the Employees table. 1.2 I want to get the contact names and phone numbers of my suppliers in Australia. 1.3...

CREATE TABLE Region ( RegionID NUMBER NOT NULL, RegionDescription CHAR(50) NOT NULL, CONSTRAINT PK_Region PRIMARY KEY (RegionID) ) / CREATE TABLE Territories ( TerritoryID VARCHAR2(20) NOT NULL,...

Northwind SQL Queries I need help with questions 20 through 32. I was able to get started on this assignment but now I'm stuck. Please help! /* DB Design & SQL Northwind SQL Lab Write the SQL queries...

I need assistance with the following SQL queries. Northwind SQL Queries I need assistance with questions 20 through 32. I was able to get started on this assignment but now I'm stuck. Please help! /*...

The Northwind database created by Microsoft contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. Here is the...

What was the total sales overall and by category for each year to our non-buying group customers? (Hint: Buying Group Customers have a buying group ID) I also need sales broken down for each month....

Use the NORTHWIND Diagram below to answer the following question: Write a single SQL statement to create the results called for in the question. Do not submit any results. Formatting counts 1....

Summarize the case study to 10-15 points in brief. Ashim Vaid had a pen in his hand but didn t know what to write. He wanted to list the attributes of the person he needed to head the human resources...

Explain the mechanism of emulsion polymerization of polystyrene. Sketch an illustration to describe each step involved in that polymerization.

Debit to Income Tax Expense for \ ( \ $ 1 0 \ ) Credit to Liability for Uncertain Tax Positions for \ $ 1 0 Debit to Liability for Uncertain Tax Positions for \ $ 1 0 Credit to Income Tax Expense for...

4. For each of the following conditions listed below, give the centering or symmetry operation responsible (in all cases n is an integer). The conditions are for reflection absences: (a) h00, h = 2n...

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...