CREATE TABLE Product (
ProductID           INTEGER,
ProdName            VARCHAR(50),
Category            VARCHAR(20),
SupplierID          CHAR(1),
HourlyRate          DECIMAL(5,2),
UnitsInStock            CHAR(2),
CONSTRAINT PKProduct PRIMARY KEY ProductID,
CONSTRAINT FKSupplier FOREIGN KEY SupplierID
REFERENCES Supplier(SupplierID)
);