[Solved]Employee Fname Minit Lname John Franklin T Wong 333445555 1955 12 08 638 Voss Houston Tx M Q37283678
EMPLOYEE Fname Minit Lname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 8886655555 Bdate sn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 999887777 1968-01-19 3321 Castle TX F 25000 987654321 4 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Belaire, TX F 43000 888665555 4 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 3334455555 JoyceA English 453453453 1972-07-31 6631 Rioe, Houston, TX F 25000 3334455555 AhmadVJabbar 9879879871969-03-29 980 Dallas, Houston, TXM 25000 9876543214 James E Brg 888665555 1937-11-10 450 Stone, Houston, TXM 55000 NULL DEPARTMENT DEPT LOCATIONS Mgr start date 98805 22 1995-01-01 333445555 987654321 888665555 1981-06-19 WORKS ON PROJECT Pnumber Plocation Dnum Essn 123456789 23456789 Hourg 32.5 7.5 2 Sugarland5 20.0 2 20.0 2 10.0 10.0 10 10.0 20 10.0 30 30.0 10 10.0 10 35.0 5.0 30 20.0 15.0 Computerization 10 Stafford 453453453 30 333445555 333445555 333445555 name Sex Bdate F 1986-04-05Daughter M 1983-10-25 Son F 1958-05-03 Spouse M 1942-02-28 Spouse M | 1988-01-04 | Son F 1988-12-30 Daughter F 1967-05-05Spouse 333446655 Alice 333445555 Theodone 333445555 Joy 987654321 23456789 Michael 123456789 Alice 123456789 30 20 20 NULL Problem 3: (10 points) Suppose each of the following Update operations is applied directly to the database above. Discuss all integrity constraints (key, entity, domain &referential) violated by each operation, if any, and the different ways of enforcing these constraints (a) Insert<‘Robert’, ‘F, “Scott’, ‘943775543’, ‘1962-12-20’, ‘2365 Newcastle Rd, Bellaire, TX’, ‘M’, 58000, 888665555, 1> into EMPLOYEE. (b) Insert<‘ProductA’, 4, Bellaire’, 2 > into PROJECT (c) Insert < ‘Production’, 4, ‘943775543’, ‘2010-06-21’> into DEPARTMENT (d) Insert< 677678989”, null, ‘40.0’> into WORKS ON CS 340-HW Assignment #3 (e) Insert< ‘123456789’, ‘Emma’, ‘F’, “Jan 15th 1980, ‘Spouse’> into DEPENDENT (f) Delete the EMPLOYEE tuple with SSN-987654321 (g) Modify the MGRSSN and MGRSTARTDATE of the DEPARTMENT tuple with DNUMBER 5 to 123456789′ and ‘1988-10-01′, respectively Show transcribed image text EMPLOYEE Fname Minit Lname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 8886655555 Bdate sn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 999887777 1968-01-19 3321 Castle TX F 25000 987654321 4 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Belaire, TX F 43000 888665555 4 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 3334455555 JoyceA English 453453453 1972-07-31 6631 Rioe, Houston, TX F 25000 3334455555 AhmadVJabbar 9879879871969-03-29 980 Dallas, Houston, TXM 25000 9876543214 James E Brg 888665555 1937-11-10 450 Stone, Houston, TXM 55000 NULL DEPARTMENT DEPT LOCATIONS Mgr start date 98805 22 1995-01-01 333445555 987654321 888665555 1981-06-19 WORKS ON PROJECT Pnumber Plocation Dnum Essn 123456789 23456789 Hourg 32.5 7.5 2 Sugarland5 20.0 2 20.0 2 10.0 10.0 10 10.0 20 10.0 30 30.0 10 10.0 10 35.0 5.0 30 20.0 15.0 Computerization 10 Stafford 453453453 30 333445555 333445555 333445555 name Sex Bdate F 1986-04-05Daughter M 1983-10-25 Son F 1958-05-03 Spouse M 1942-02-28 Spouse M | 1988-01-04 | Son F 1988-12-30 Daughter F 1967-05-05Spouse 333446655 Alice 333445555 Theodone 333445555 Joy 987654321 23456789 Michael 123456789 Alice 123456789 30 20 20 NULL Problem 3: (10 points) Suppose each of the following Update operations is applied directly to the database above. Discuss all integrity constraints (key, entity, domain &referential) violated by each operation, if any, and the different ways of enforcing these constraints (a) Insert into EMPLOYEE. (b) Insert into PROJECT (c) Insert into DEPARTMENT (d) Insert into WORKS ON CS 340-HW Assignment #3 (e) Insert into DEPENDENT (f) Delete the EMPLOYEE tuple with SSN-987654321 (g) Modify the MGRSSN and MGRSTARTDATE of the DEPARTMENT tuple with DNUMBER 5 to 123456789’ and ‘1988-10-01’, respectively
Expert Answer
Answer to EMPLOYEE Fname Minit Lname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 8886655555 Bdate sn D… . . .
OR
