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 NOT NULL,
PromotionName VARCHAR NOT NULL,
PromotionDiscount DECIMAL NOT NULL,
PRIMARY KEYPromotionID
;
CREATE TABLE Category
CategoryID CHAR NOT NULL,
CategoryName VARCHAR NOT NULL,
CategoryDesc VARCHAR NOT NULL,
PRIMARY KEYCategoryID
;
CREATE TABLE Chocolate
ChocolateID CHAR NOT NULL,
ChocolateName VARCHAR NOT NULL,
ChocolateDesc VARCHAR NOT NULL,
ChocolatePrice DECIMAL NOT NULL,
ChocolateWeight INT NOT NULL,
CategoryID CHAR NOT NULL,
PRIMARY KEYChocolateID
FOREIGN KEY CategoryID REFERENCES CategoryCategoryID
;
CREATE TABLE Discount
PromotionID CHAR NOT NULL,
ChocolateID char NOT NULL,
StartDate DATETIME NOT NULL,
EndDate DATETIME NOT NULL,
PRIMARY KEY PromotionID ChocolateID
FOREIGN KEY PromotionID REFERENCES PromotionPromotionID
FOREIGN KEY ChocolateID REFERENCES ChocolateChocolateID
;
CREATE TABLE Customer
CustomerID CHAR NOT NULL,
CustomerName VARCHAR NOT NULL,
CustomerEmail VARCHAR NOT NULL,
CustomerPhNum VARCHAR NOT NULL,
PRIMARY KEY CustomerID
;
CREATE TABLE Review
ReviewID CHAR NOT NULL,
ReviewRating DECIMAL NOT NULL,
ReviewComment VARCHAR NOT NULL,
ReviewDate DATETIME NOT NULL,
CustomerID CHAR NOT NULL,
ChocolateID CHAR NOT NULL,
PRIMARY KEY ReviewID
FOREIGN KEY ChocolateID REFERENCES ChocolateChocolateID
FOREIGN KEY CustomerID REFERENCES CustomerCustomerID
;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
