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?

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

See similar textbooks

Similar questions

Give me a genuine SQL database.
How does a database management system function? What is it?
Database audit trail—what is it? Explain Extended Events in 60 words or less.
How can we build a database using PHP and MySQL?
A database has data and relationships. Select one: True False
A database driver accomplishes what?
what are 5 risks and 5 benefits to having a health database open for public use?
What are your thoughts on database technology right now, as well as your predictions for the future?
Do you know what a database administrator does??
What are your current thoughts on database technology, and what are your predictions for the future?
What is necessary in the real world to construct a database? Compile a list of the most popular messaging applications accessible. If so, do they follow the same standards as SMS?
Who is at danger of losing their privacy and civil rights as a result of the use of databases?