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, WorksOn and DeptLocations. 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;
INSERT INTO department DNumber MgrSSN MgrStartDate
VALUES Administartion;
INSERT INTO department DNumber MgrSSN MgrStartDate
VALUES Headquarters;
#Dependents
INSERT INTO Dependents ESSN DependentName, Gender, DOB, Relationship
VALUES 'Alice', F 'Daughter';
INSERT INTO Dependents ESSN DependentName, Gender, DOB, Relationship
VALUES 'Theodore', M 'Son';
INSERT INTO Dependents ESSN DependentName, Gender, DOB, Relationship
VALUES 'Joy', F 'Spouse';
INSERT INTO Dependents ESSN DependentName, Gender, DOB, Relationship
VALUES 'Abner', M 'Spouse';
INSERT INTO Dependents ESSN DependentName, Gender, DOB, Relationship
VALUES 'Michael', M 'Son';
INSERT INTO Dependents ESSN DependentName, Gender, DOB, Relationship
VALUES 'Alice', F 'Daughter';
INSERT INTO Dependents ESSN DependentName, Gender, DOB, Relationship
VALUES 'Elizabeth', F 'Spouse';
#DeptLocations
INSERT INTO DeptLocationsDNumberDLocation
VALUES 'Houston';
INSERT INTO DeptLocationsDNumberDLocation
VALUES 'Stafford';
INSERT INTO DeptLocationsDNumberDLocation
VALUES 'Bellaire';
INSERT INTO DeptLocationsDNumberDLocation
VALUES 'Sugarland';
INSERT INTO DeptLocationsDNumberDLocation
VALUES 'Houston';
#Project
INSERT INTO Project PName PNumber, PLocation, DNum
VALUES ProductX 'Bellaire', ;
INSERT INTO Project PName PNumber, PLocation, DNum
VALUES ProductY 'Sugarland', ;
INSERT INTO Project PName PNumber, PLocation, DNum
VALUES ProductZ 'Houston', ;
INSERT INTO Project PName PNumber, PLocation, DNum
VALUES Computerization 'Stafford', ;
INSERT INTO Project PName PNumber, PLocation, DNum
VALUES Reorganization 'Houston', ;
INSERT INTO Project PName PNumber, PLocation, DNum
VALUES Newbenefits 'Stafford', ;
#WorksOn
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES ;
INSERT INTO WorksOn ESSN PNO, Hours
VALUES 'NULL';
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
