Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow? Employee FName LName SSN BDate Salary SuperSSN DNo Smith Jone 123 1/2/1979 2100JD NULL 10 3/6/1982 20/9/1980 || 3650JD 1/12/1970 Susan Adams 432 1547JD 123 10 James Ford 587 983 20 Sali Miller 983 890JD 123 30 Department DNo DName 10 Headquarter 20 Accounting 30 IT Insert 2. Insert < 'Jasmine', 'Rani', 321, 3/9/1982, 3000, NULL, 30> into EMPLOYEE. 3. Insert < 'Jasmine', 'Rani', 923, 3/19/1980, '3000JD', NULL, 30> into EMPLOYEE.
Which relational constraints would be violated if the following operation were applied to the COMPANY
Insert:
2. Insert < 'Jasmine', 'Rani', 321, 3/9/1982, 3000, NULL, 30> into EMPLOYEE.
3. Insert < 'Jasmine', 'Rani', 923, 3/19/1980, '3000JD', NULL, 30> into EMPLOYEE.
4. Insert <123456, 'Rani', 321, 3/9/1985, '3000$', 432, 10> into EMPLOYEE.
5. Insert <400,'Planning'> into DEPARTMENT.
6. Insert <123456, 'Rani', 123, 3/9/1985, '3500JD', 432, 10> into EMPLOYEE.
7. Insert <30,'Planning'> into DEPARTMENT.
8. Insert < 'Jasmine', 'Rani',NULL, 30/9/1977, '4000JD', 587, 10> into EMPLOYEE.
9. Insert <NULL,'Planning'> into DEPARTMENT.
10. Insert < 'Jasmine', 'Rani',222, 3/2/1980, 3000, 587, 50> into EMPLOYEE .
11. Insert < 'Alice', 'Rani',222, 30/2/1976, 3000, 687, 10> into EMPLOYEE.
12. Insert < 'Jasmine', 'Rani',NULL, 3/22/1976, '1000JD', 587, 50> into EMPLOYEE.
13. Insert < 'Sali', 'Rani', 'NULL', 3/2/1969, '6000JD', 587, 40> into EMPLOYEE.
14. Insert < 'Jasmine', 'Rani', 123, 3/2/76, '3200JD', 587, 60> into EMPLOYEE.
Delete:
1. Delete the DEPARTMENT tuple with DNo =20
2. Delete the EMPLOYEE tuple with FName ='Smith'
3. Delete the EMPLOYEE tuple with SSN=432
Modify:
1. Update the SALARY of the EMPLOYEE tuple with SSN=432 to 2800.
2. Update the DNO of the EMPLOYEE tuple with SSN=432 to 70.
3. Update the DNO of the DEPARTMENT tuple with DName ='IT' to 40.
4. Update the DNO of the DEPARTMENT tuple with DName ='IT' to 10.
5. Update the SSN of the EMPLOYEE tuples with FName ='Smith' to NULL.
6. Update the SSN of the EMPLOYEE tuples to 566.
Step by step
Solved in 2 steps
