Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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 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.

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question

Which relational constraints would be violated if the following operation were applied to the COMPANY database snapshot illustrated bellow?
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.

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.
Transcribed Image Text: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.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS