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

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Can someone please explain to me ASAP??!!! This is database system
Q2. (4 points) Assume we have the following two tables and their instances:
CREATE TABLE Employee-Work (age INTEGER,
CREATE TABLE Project( pid CHAR(10),
Project
pid
100
102
200
101
ssn CHAR(10),
name CHAR(50),
pid CHAR(10) Not Null,
PRIMARY KEY (ssn),
FOREIGN KEY (pid) REFERENCES Project ON Delete CASCADE)
budget
500K
400K
700K
100K
budget CHAR(10),
PRIMARY KEY (pid))
Employee-work
Ssn
5380 Joe
5381
Ali
5382 Jill
DELETE
FROM Project P
WHERE P.pid = 100 or P.pid=200
name
pid
102
101
100
What will be the new instances of the tables Employee-work and Project after running the
following query?
Transcribed Image Text:Q2. (4 points) Assume we have the following two tables and their instances: CREATE TABLE Employee-Work (age INTEGER, CREATE TABLE Project( pid CHAR(10), Project pid 100 102 200 101 ssn CHAR(10), name CHAR(50), pid CHAR(10) Not Null, PRIMARY KEY (ssn), FOREIGN KEY (pid) REFERENCES Project ON Delete CASCADE) budget 500K 400K 700K 100K budget CHAR(10), PRIMARY KEY (pid)) Employee-work Ssn 5380 Joe 5381 Ali 5382 Jill DELETE FROM Project P WHERE P.pid = 100 or P.pid=200 name pid 102 101 100 What will be the new instances of the tables Employee-work and Project after running the following query?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education