Question: Can someone help me figure out why my data isnt showing up in my table SQLWORKBENCH? Im having trouble for the tables Project, Works _

Can someone help me figure out why my data isnt showing up in my table SQLWORKBENCH? Im having trouble for the tables Project, Works_On, and Dept_Locations. Some of my table data has showed up and the ones listed do not. I provided example pic which boxes should i check? &
Here is my code:
#department
INSERT INTO department (DNumber, MgrSSN, MgrStartDate)
VALUES ('Research','5','333445555','1988-05-22');
INSERT INTO department (DNumber, MgrSSN, MgrStartDate)
VALUES ('Administartion','4','987654321','1995-1-1');
INSERT INTO department (DNumber, MgrSSN, MgrStartDate)
VALUES ('Headquarters','1','888665555','1981-6-19');
#Dependents
INSERT INTO Dependents (ESSN, Dependent_Name, Gender, DOB, Relationship)
VALUES ('333445555', 'Alice', 'F','1986-04-05', 'Daughter');
INSERT INTO Dependents (ESSN, Dependent_Name, Gender, DOB, Relationship)
VALUES ('333445555', 'Theodore', 'M','1983-10-25', 'Son');
INSERT INTO Dependents (ESSN, Dependent_Name, Gender, DOB, Relationship)
VALUES ('333445555', 'Joy', 'F','1958-05-03', 'Spouse');
INSERT INTO Dependents (ESSN, Dependent_Name, Gender, DOB, Relationship)
VALUES ('987654321', 'Abner', 'M','1942-02-28', 'Spouse');
INSERT INTO Dependents (ESSN, Dependent_Name, Gender, DOB, Relationship)
VALUES ('12345678', 'Michael', 'M','1988-01-04', 'Son');
INSERT INTO Dependents (ESSN, Dependent_Name, Gender, DOB, Relationship)
VALUES ('123456789', 'Alice', 'F','1988-12-30', 'Daughter');
INSERT INTO Dependents (ESSN, Dependent_Name, Gender, DOB, Relationship)
VALUES ('123456789', 'Elizabeth', 'F','1967-05-05', 'Spouse');
#Dept_Locations
INSERT INTO Dept_Locations(DNumber,DLocation)
VALUES ('1','Houston');
INSERT INTO Dept_Locations(DNumber,DLocation)
VALUES ('4','Stafford');
INSERT INTO Dept_Locations(DNumber,DLocation)
VALUES ('5','Bellaire');
INSERT INTO Dept_Locations(DNumber,DLocation)
VALUES ('5','Sugarland');
INSERT INTO Dept_Locations(DNumber,DLocation)
VALUES ('5','Houston');
#Project
INSERT INTO Project (PName, PNumber, PLocation, DNum)
VALUES ('ProductX','1', 'Bellaire', '5');
INSERT INTO Project (PName, PNumber, PLocation, DNum)
VALUES ('ProductY','2', 'Sugarland', '5');
INSERT INTO Project (PName, PNumber, PLocation, DNum)
VALUES ('ProductZ','3', 'Houston', '5');
INSERT INTO Project (PName, PNumber, PLocation, DNum)
VALUES ('Computerization','10', 'Stafford', '4');
INSERT INTO Project (PName, PNumber, PLocation, DNum)
VALUES ('Reorganization','20', 'Houston', '1');
INSERT INTO Project (PName, PNumber, PLocation, DNum)
VALUES ('Newbenefits','30', 'Stafford', '4');
#Works_On
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('123456789','1','32.5');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('123456789','2','7.5');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('666884444','3','40.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('453453453','1','20.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('453453453','2','20.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('333445555','2','10.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('333445555','3','10.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('333445555','10','10.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('333445555','20','10.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('999887777','30','30.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('999887777','10','10.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('987987987','10','35.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('987987987','30','5.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('987654391','30','20.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('987654391','20','15.0');
INSERT INTO Works_On (ESSN, PNO, Hours)
VALUES ('888665555','20', 'NULL');
Can someone help me figure out why my data isnt

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!