Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Consider the following Database State. EMPLOYEE Frame Minit John B Franklin T L Alicia TJ Jennifer S Ramesh K Joyce Ahmad V James E

image text in transcribed

image text in transcribed

2. Consider the following Database State. EMPLOYEE Frame Minit John B Franklin T L Alicia TJ Jennifer S Ramesh K Joyce Ahmad V James E Lname San Bdate Address Sex Salary Super_ssn Dno Smith 1234567891965-01-09 731 Fondren, Houston, TX M 30000 3334455555 Wong | 333445555 1955-12-08 638 Voss, Houston, TX |M |40000 8886655555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 9876543214 Wallace 9876543211941-06-20 291 Berry, Bellaire, TX F 43000 888665555 4 Narayan 6668844441962-09-15 975 Fire Oak Humble, TX Narayan 666BB4444 | 1962 M 38000 3334455555 English 453453453 1972-07-31 5631 Rice, Houston, TXF 25000 3334455555 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TXM 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TXM 55000 NULL 1 DEPARTMENT Dnumber Drame Research Administration Headquarters Mgr_san 333445555 987654321 888665555 Mgr_start date 1988-05-22 1 995-01-01 1981-06-19 4 DEPT LOCATIONS Dnumber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland Houston I PROJECT Pno Hours Pname Pnumber 1 2 Dnum 5 32.5 2 7.5 40.0 WORKS ON Essn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 ProductX ProductY Productz Computerization Reorganization Newbenefits Plocation Bellaire Sugarland Houston Stafford Houston Stafford 20.0 10 2 20 30 4 20.0 10.0 10.0 10.0 10.0 30.0 10 20 Sex 999887777 30 10 10.0 M 35.0 5.0 F 999887777 987987987 987987987 987654321 987654321 888665555 DEPENDENT Esen 333445555 333445555 333445555 987654321 123456789 123456789 123456789 10 30 30 20 20 Dependent name Alice Theodore Joy Abner Michael Alice Elizabeth Bdate 1986-04-05 1983-10-25 1958-05-03 1942-02-28 1988-01-04 1988-12-30 1967-05-05 Relationship Daughter Son Spouse Spouse Son Daughter Spouse 20.0 15.0 M F F F NULL 1. Which of the operations will be okay, or which of the operations will violate integrity constrains (Which Integrity Constraints)? a. Insert into EMPLOYEE. b. Insert into EMPLOYEE. c. Insert into EMPLOYEE. d. Insert into EMPLOYEE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Foundations Technology Fundamentals For IT Success

Authors: Bob Bryla

1st Edition

0782143725, 9780782143720

More Books

Students also viewed these Databases questions

Question

6. How do histories influence the process of identity formation?

Answered: 1 week ago