CREATE TABLE Employee-Work (age INTEGER, ssn CHAR(10), name CHAR(50), pid CHAR(10) Not Null, PRIMARY KEY (ssn),...

 

Transcribed Image Text:

CREATE TABLE Employee-Work (age INTEGER, ssn CHAR(10), name CHAR(50), pid CHAR(10) Not Null, PRIMARY KEY (ssn), FOREIGN KEY (pid) REFERENCES Project ON Delete CASCADE) CREATE TABLE Project( pid CHAR(10), Project pid 100 102 200 101 budget 500K 400K 700K 100K budget CHAR(10), PRIMARY KEY (pid)) Employee-work Ssn name 5380 Joe 5381 Ali 5382 Jill pid 102 101 100 What will be the new instances of the tables Employee-work and Project after running the following query? DELETE FROM Project P WHERE P.pid=100 or P.pid-200 CREATE TABLE Employee-Work (age INTEGER, ssn CHAR(10), name CHAR(50), pid CHAR(10) Not Null, PRIMARY KEY (ssn), FOREIGN KEY (pid) REFERENCES Project ON Delete CASCADE) CREATE TABLE Project( pid CHAR(10), Project pid 100 102 200 101 budget 500K 400K 700K 100K budget CHAR(10), PRIMARY KEY (pid)) Employee-work Ssn name 5380 Joe 5381 Ali 5382 Jill pid 102 101 100 What will be the new instances of the tables Employee-work and Project after running the following query? DELETE FROM Project P WHERE P.pid=100 or P.pid-200