Question: Consider the EMPLOYEE table's constraint EMPSUPERFK as specified in Figure 4.2 is changed to read as follows: CONSTRAINT EMPSUPERFK FOREIGN KEY (SUPERSSN) REFERNCES EMPLOYEE(SSN) ON

Consider the EMPLOYEE table's constraint EMPSUPERFK as specified in Figure 4.2 is changed to read as follows:
CONSTRAINT EMPSUPERFK
FOREIGN KEY (SUPERSSN) REFERNCES EMPLOYEE(SSN)
ON DELETE CASCADE ON UPDATE CASCADE,
Answer the following questions:
a. What happens when the following command is run on the database state shown in Figure 5.6? DELETE EMPLOYEE WHERE LNAME = 'Borg'
b. Is it better to CASCADE or SET NULL in case of EMPSUPERFK constraint ON DELETE?

Step by Step Solution

★★★★★

3.33 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The James E Borg entry is deleted from the table and each employee with ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

888-CS-DB (2290).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the following relational schema and briefly answer the questions that follow: 1. Define a table constraint on Emp that will ensure that every employee makes at least $10,000. 2. Define a...

Consider the following BCNF schema for a portion of a simple corporate database (type information is not relevant to this question and is omitted): Emp (eid, ename, addr, sal, age, yrs, deptid) Dept...

Use the following description of the operations of the RC_Charter2 Company to complete this exercise. ¢ The RC_Charter2 Company operates a fleet of aircraft under the Federal Air Regulations...

Consider that the EMPLOYEE tables constraint EMPSUPERFK as specified in Figure 6.2 is changed to read as follows: CONSTRAINT EMPSUPERFK FOREIGN KEY (Super_ssn) REFERENCES EMPLOYEE(Ssn) ON DELETE...

Uatabase Management System Design Test 3 Spring 2018 2. (20 points) Consider the EMPLOYEE table's constraint with the name EMPSUPERFK as speci in the Figure below CREATE TABLE EMPLOYEE Dno INT...

The states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation Select one: O physical data independence NOT NULL constraint O Entity...

Consider the EMPLOYEE table's constraint EMPSUPERFK as specified below: CONSTRAINT EMPSUPERFK FOREIGN KEY (Super_ssn) REFERENCES EMPLOYEE(Ssn) ON DELETE CASCADE ON UPDATE CASCADE EMPLOYEE Fname Minit...

oracle sql statement help. I will upvote a clear, detailed response. Thank you!! more joins (inner and outer), subqueries and other SQL issues You are suggested to adopt a user friendly prefix string...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Par owns 91.37% of Sub Corp. Par sold depreciable assets to Sub on January 1, Year 3, at a before-tax gain of $48,917. On January 1, Year 4, Sub sold depreciable assets to Par at a before-tax gain of...

You can get the same return for lower risk by holding a basket of two stocks rather than just one, when the return on these stocks are uncorrelated. Discuss what difference it would make if the...

Continue to evaluate your funds after your investment. Evaluate your investments on a regular basis. If necessary, sell funds that no longer are helping you achieve your investment objectives or that...

Watch for news programs or summaries of current events in which the announcers specifically talk about Lessons Learned. Describe the context of the discussions in terms of value addition or placing...

Consider the EER design for the ONLINE_AUCTION database that was modeled using a tool like ERwin or Rational Rose in Laboratory Exercise 4.29. Using the SQL schema generation feature of the modeling...

Consider the EER design for the GRADE_BOOK database that was modeled using a tool like ERwin or Rational Rose in Laboratory Exercise 4.28. Using the SQL schema generation feature of the modeling...

Consider the ER design for the MAIL_ORDER database that was modeled using a tool like ERwin or Rational Rose in Laboratory Exercise 3.32. Using the SQL schema generation feature of the modeling tool,...

Over time academics and practitioners have shown that CAPM does not fully describe the returns on stocks. They showed this by finding large persistent alphas on the returns. Specifically, if we let...

Bill deposits $100 at the end of each year for 13 years into fund A. Seth deposits $100 at the end of each year for 13 years into fund B. Fund A earns an annual effective rate of 15% for the first 5...

The Presley Corporation is about to go public. It currently has aftertax earnings of $7,700,000, and 2,300,000 shares are owned by the present stockholders (the Presley family). The new public issue...