Question: Given the following DDL statement to create table EMPLOYEEE. Consider the EMPLOYEE tables constraint EMPSUPERFK is changed to read as follows:Answer the following questions:a .

Given the following DDL statement to create table EMPLOYEEE. Consider the EMPLOYEE tables constraint EMPSUPERFK is changed to read as follows:Answer the following questions:a

.

What happens when the following command is run on the COMPANY relational database given above?DELETE FROM EMPLOYEE WHERE Lname

=

Borgb. Is it better to CASCADE or SET NULL in case of EMPSUPERFK constraint ON DELETE?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Given the following DDL statement to create table EMPLOYEEE. Consider the EMPLOYEE tables constraint EMPSUPERFK is changed to read as follows:Answer the following questions:a . What happens when the...

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...

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...

BYGB/ISGB 7973: ASSIGNMENT 2 DATABASE MANAGEMENT SQL Assignment Part I You may want to use the CreateTable_TG.ddl that we used for the TradeGroup an exemplar for this question. This exercise is based...

PART 1 Banking Database Design Banking DDL: Consider the bank database schema given below. Write the SQL DDL corresponding to this schema ( i . e . the CREATE TABLE statements ) . When you are...

Consider the relational tables created by the execution of the following CREATE TABLE statements. CREATE TABLE EMPLOYEE ENUM DECIMAL (12) NOT NULL, FNAME VARCHAR (50) NOT NULL, INITIALS VARCHAR (5)...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...

Please Answer the following 1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is...

Using the AICPA Code of Professional Conduct as your reference, what is covered in these standards that relates to the preparation of financial statements? Do you think these standards are...

Assume you are managing the portfolio of the following three stocks. Stock A B Shares 10,000 25,000 Beta .75 1.20 Price $40 $10 C 10,000 1.50 $35 The risk free is 1.10%. The above stocks are mostly...

Suppose you are thinking of purchasing the stock of Facebook You expect Facebook to pay 2.00 dividend in one year. You believe you can sell the stock at 14.00 at year one. You are expected to earn...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

KEY QUESTION Corporations often distribute profits to their shareholders in the form of dividends, which are simply checks mailed out to shareholders. Suppose that you have the chance to buy a share...

What are the major categories of firms that make up the U.S. financial services industry? Did the bank and thrift share of the financial services market rise, fall, or stay the same between 1980 and...

How is the chairperson of the Federal Reserve System selected? Describe the relationship between the Board of Governors of the Federal Reserve System and the 12 Federal Reserve Banks. What is the...