It won\'t let me insert my Orders values or Part order values. For Orders it kee

Question

It won't let me insert my Orders values or Part order values. For Orders it keeps saying Customer.cID does not exist but as you can see I have the foreign key set for the orders table.

CREATE TABLE `jasocook_366f16`.`Employee` (
`eID` INT NOT NULL,
`fName` VARCHAR(45) NULL,
`lName` VARCHAR(45) NULL,
`zip` INT NULL,
PRIMARY KEY (`eID`));

CREATE TABLE `jasocook_366f16`.`Telephone` (
`tID` INT NOT NULL,
`eID` INT NULL,
`tNumber` INT NULL,
PRIMARY KEY (`tID`),
foreign key (eID) references Employee(eID));

CREATE TABLE `jasocook_366f16`.`Customer` (
`cID` INT NOT NULL,
`fName` VARCHAR(45) NULL,
`lName` VARCHAR(45) NULL,
`street` VARCHAR(50) NULL,
`city` VARCHAR(100) NULL,
`zip` INT NULL,
PRIMARY KEY (`cID`));

CREATE TABLE `jasocook_366f16`.`Part` (
`pID` INT NOT NULL,
`pName` VARCHAR(1000) NULL,
`price` INT NULL,
`quantity` INT NULL,
PRIMARY KEY (`pID`));

CREATE TABLE `jasocook_366f16`.`Orders` (
`oID` INT NOT NULL,
`rDate` DATE NULL,
`sDate` DATE NULL,
`cID` INT NULL,
`eID` INT NULL,
PRIMARY KEY (`oID`),
foreign key (cID) references Customer(cID),
foreign key (eID) references Employee(eID));

CREATE TABLE `jasocook_366f16`.`PartOrder` (
`pOID` INT NOT NULL,
`pID` INT NULL,
`oID` INT NULL,
`quantity` INT NULL,
PRIMARY KEY (`pOID`),
foreign key (pID) references Part(pID),
foreign key (oID) references Orders(oID));

insert into Employee values(1,'Jason','Cook', 58104);
insert into Employee values(2,'Alison','Olson',58104);

insert into Telephone values(1,1,1234567891);
insert into Telephone values(2,2,234567891);

insert into Customer values(1,'Pam','Wiseman', '123 West Palm St.','Chicago',23456);
insert into Customer values(2,'John','Wayne', '123 Bang Bang St.','Austin',55555);

insert into Part values(1,'Part1', 120, 2);
insert into Part values(2,'Part2', 500, 2);

insert into Orders values(1,'09/28/2016','09/13/2016',Customer.cID(1),eID(1));
insert into Orders values(2,'10/09/2016','09/30/2016',cID(2),eID(2));

insert into PartOrder values(1,Part.pID(1), Orders.oID(1),1);
insert into PartOrder values(2,Part.pID(2),Orders.oID(2),1);

HELP!

Explanation / Answer

Please use below commands.

insert into Orders values(1,'09/28/2016','09/13/2016',1,1);
insert into Orders values(2,'10/09/2016','09/30/2016',2,2);

insert into PartOrder values(1,1,1,1);
insert into PartOrder values(2,2,2,1);

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.