Question

^{I need to add constraints but I am unsure how. I also need FK in this script. Does that make sense.}

CREATE TABLE Orders(OrderNumber INT (100) Primary Key,ProductId VARCHAR (25) NOT NULL,Quanity INT(100) NOT NULL,ShipDate DATE );

INSERT INTO Orders VALUES(2067980, '5678', '1' , '05-02-2019');
INSERT INTO Orders VALUES(2070369,'6867','2','09-06-2019');
INSERT INTO Orders VALUES(2039542, '4652', '10', '11-30-2019');

CREATE TABLE Employee(EmployeeID INT(15) Primary KEY,EmployeeFirstName VARCHAR (25) NOT NULL,EMployeeLastName VARCHAR (25) NOT NULL,
EmployeeAddress VARCHAR (45) NOT NULL,EmployeeCity VARCHAR (25) NOT NULL,EmployeeState VARCHAR (25) NOT NULL,Zipcode VARCHAR (25) NOT NULL);

INSERT INTO `Employee` VALUES(2468, 'Jason', 'Harmon', '10 Western Court', 'Howell', 'NJ', '07731');

INSERT INTO `Employee` VALUES(2469, 'Gary', 'Hodgens', '1 Lewis Street', Secaucus', 'NJ', '07094');

INSERT INTO `Employee` VALUES(2461, 'Mayla', 'Slate', '18 Sand Road', 'Milltown', 'NJ', '08850');

CREATE TABLE Customer( CustomerID int (35) PRIMARY KEY,CustomerFirstName varchar (25),CustomerLastName varchar (25) NOT NULL,
CustomerAddress varchar (45) NOT NULL,CustomerState varchar (25),CustomerZip int (20) NOT NULL) ;

INSERT INTO Customer VALUES(01234, 'John', 'Smith', '3 Evergreen Drive', 'NJ', '9950');
INSERT INTO Customer VALUES(01235, 'Dave', 'Tee', '6 Devry Road', 'IL', '9961');
INSERT INTO Customer VALUES(01236, 'Jane', 'White', '9 Conover Avenue', 'VA', '9982');

CREATE TABLE Product(ProductNumber INT (10) PRIMARY KEY,ProductName VARCHAR(50) NOT NULL,ProductModel VARCHAR (25),ProductPrice Decimal (10),
Manufatcurer VARCHAR (25));

INSERT INTO Product VALUES(5678, 'TV', '60inch', '350', 'LG');
INSERT INTO Product VALUES(4652, 'Laptop', '17inch', '400', 'Toshiba');
INSERT INTO Product VALUES(6867, 'Radio', 'CDPlayer', '150', 'Bose');

CREATE TABLE InventoryReport(ItemNumber VARCHAR (25) PRIMARY KEY,ItemSold int(25) NOT NULL,ItemsOnHand int (500) NOT NULL,
BackOrdered varchar(500)) ;

INSERT INTO InventoryReport VALUES(5678, '1', '100', '200');
INSERT INTO InventoryReport VALUES(6867, '2', '50', '150');
INSERT INTO InventoryReport VALUES(4652, '10', '300', '400');

CREATE TABLE DistributionChannel( TrackingNumber VARCHAR (35) Primary Key,CarrierName VARCHAR (45) NOT NULL,CarrierType VARCHAR (45)) ;

INSERT INTO DistributionChannel VALUES(6694, 'Fedex', 'Truck');
INSERT INTO DistributionChannel VALUES(6695, 'UPS', 'Van');
INSERT INTO DistributionChannel VALUES(6696, 'USPS', 'Car');

CREATE TABLE Payment( CustomerAcountNumber INT(50) NOT NULL,PaymentType VARCHAR (25),Total Decimal (20));

INSERT INTO Payment VALUES(9950, 'Visa','100.00');
INSERT INTO Payment VALUES(9961, 'Echeck','25.00');
INSERT INTO Payment VALUES(9982, 'Mastercard', '32.00');

Answer 1

TO ADD CONSTRAINT PLEASE FOLLOW THE BELOW SYNTAX:

The ADD CONSTRAINT command is used to create a constraint after a table is already created.

The following SQL adds a constraint named "PK_Person" that is a PRIMARY KEY constraint on multiple columns (ID and LastName):

Example:

ALTER TABLE Persons
ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);

In this table I think its better for you to add a FK.