Question: Show me the steps to solve the mistake: CREATE TABLE Promotion ( PromotionID CHAR ( 6 ) NOT NULL, PromotionName VARCHAR ( 5 0 )

Show me the steps to solve the mistake:
CREATE TABLE Promotion (
PromotionID CHAR(6) NOT NULL,
PromotionName VARCHAR(50) NOT NULL,
PromotionDiscount DECIMAL(4,1) NOT NULL,
PRIMARY KEY(PromotionID)
);
CREATE TABLE Category (
CategoryID CHAR(6) NOT NULL,
CategoryName VARCHAR(50) NOT NULL,
CategoryDesc VARCHAR(200) NOT NULL,
PRIMARY KEY(CategoryID)
);
CREATE TABLE Chocolate (
ChocolateID CHAR(6) NOT NULL,
ChocolateName VARCHAR(50) NOT NULL,
ChocolateDesc VARCHAR(200) NOT NULL,
ChocolatePrice DECIMAL(5,2) NOT NULL,
ChocolateWeight INT NOT NULL,
CategoryID CHAR(6) NOT NULL,
PRIMARY KEY(ChocolateID),
FOREIGN KEY (CategoryID) REFERENCES Category(CategoryID)
);
CREATE TABLE Discount (
PromotionID CHAR(6) NOT NULL,
ChocolateID char(6) NOT NULL,
StartDate DATETIME NOT NULL,
EndDate DATETIME NOT NULL,
PRIMARY KEY (PromotionID, ChocolateID),
FOREIGN KEY (PromotionID) REFERENCES Promotion(PromotionID),
FOREIGN KEY (ChocolateID) REFERENCES Chocolate(ChocolateID)
);
CREATE TABLE Customer (
CustomerID CHAR(6) NOT NULL,
CustomerName VARCHAR(70) NOT NULL,
CustomerEmail VARCHAR(100) NOT NULL,
CustomerPhNum VARCHAR(32) NOT NULL,
PRIMARY KEY (CustomerID)
);
CREATE TABLE Review (
ReviewID CHAR(6) NOT NULL,
ReviewRating DECIMAL(2,0) NOT NULL,
ReviewComment VARCHAR(255) NOT NULL,
ReviewDate DATETIME NOT NULL,
CustomerID CHAR(6) NOT NULL,
ChocolateID CHAR(6) NOT NULL,
PRIMARY KEY (ReviewID),
FOREIGN KEY (ChocolateID) REFERENCES Chocolate(ChocolateID),
FOREIGN KEY (CustomerID) REFERENCES Customer(CustomerID)
);

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 Programming Questions!