Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Lname Ssn Bdate Address Sex Salary Super_ssn Dno EMPLOYEE Fname Minit Dno John B 5 Franklin T 5 Alicia 4 J s Jennifer Lname Ssn Bdate Address Sex Salary Super_ssn Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 4 5 Ramesh Joyce Ahmad K A V 5 4 James E 1 How many tuples are present in the EMPLOYEE table when the following command is run on the database state and schema shown in the above figure? DELETE EMPLOYEE WHERE LNAME = 'Borg Oo 02 06 04
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started