Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Suppose each of the following update operations is applied directly to the below database state. Discuss which integrity constraints were violated by each operation and how you can enforce these constraints to ensure no violation occurs. If an operation does not violate any constraints, briefly explain why.  a) Insert <’D1’, 'Stafford'> into Department_Locations table b) Insert <6, ‘Stafford’> into Department_Locations table c) Insert into Department_Locations table

Suppose each of the following update operations is applied directly to the below database state. Discuss which integrity constraints were violated by each operation and how you can enforce these constraints to ensure no violation occurs. If an operation does not violate any constraints, briefly explain why.  a) Insert <’D1’, 'Stafford'> into Department_Locations table b) Insert <6, ‘Stafford’> into Department_Locations table c) Insert into Department_Locations table

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Suppose each of the following update operations is applied directly to the below database state.
Discuss which integrity constraints were violated by each operation and how you can enforce these
constraints to ensure no violation occurs. If an operation does not violate any constraints, briefly
explain why. 


a) Insert <’D1’, 'Stafford'> into Department_Locations table
b) Insert <6, ‘Stafford’> into Department_Locations table
c) Insert <null, ‘Stafford’> into Department_Locations table

EMPLOYEE Fname John Sen Bdate Address Minit Lname B Smith Sex 123456789 1965-01-09 731 Fondren, Houston, TX M Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M DEPARTMENT Dname Research Administration Headquarters WORKS ON Esen 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Dnumber 5 4 1 Pno 1 2 3 1 2 2 3 10 20 30 10 10 30 30 20 20 Hours 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 20.0 15.0 NULL Mgr san 333445555 987654321 888665555 DEPENDENT Esan 333445555 333445555 333445555 987654321 123456789 123456789 123456789 Mgr start date 1988-05-22 1995-01-01 1981-06-19 PROJECT Alice Pname ProductX ProductY ProductZ Computerization Reorganization Newbenefits Dependent_name Sex F Theodore Joy Abner Michael Alice Elizabeth Salary Super_san Dno 30000 333445555 5 40000 888665555 5 25000 987654321 4 43000 888665555 4 38000 333445555 5 25000 333445555 25000 987654321 55000 NULL M F M M F F DEPT LOCATIONS Pnumber 1 2 3 10 20 30 Dnumber 1 4 5 5 5 Plocation Bellaire Sugarland Houston Stafford Houston Stafford Dlocation Houston Stafford Bellaire 4 Sugarland Houston Dnum 5 5 5 4 1 4 Bdate 1986-04-05 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 1988-12-30 Daughter Spouse 1967-05-05 Relationship Daughter
Transcribed Image Text:EMPLOYEE Fname John Sen Bdate Address Minit Lname B Smith Sex 123456789 1965-01-09 731 Fondren, Houston, TX M Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M DEPARTMENT Dname Research Administration Headquarters WORKS ON Esen 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Dnumber 5 4 1 Pno 1 2 3 1 2 2 3 10 20 30 10 10 30 30 20 20 Hours 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 20.0 15.0 NULL Mgr san 333445555 987654321 888665555 DEPENDENT Esan 333445555 333445555 333445555 987654321 123456789 123456789 123456789 Mgr start date 1988-05-22 1995-01-01 1981-06-19 PROJECT Alice Pname ProductX ProductY ProductZ Computerization Reorganization Newbenefits Dependent_name Sex F Theodore Joy Abner Michael Alice Elizabeth Salary Super_san Dno 30000 333445555 5 40000 888665555 5 25000 987654321 4 43000 888665555 4 38000 333445555 5 25000 333445555 25000 987654321 55000 NULL M F M M F F DEPT LOCATIONS Pnumber 1 2 3 10 20 30 Dnumber 1 4 5 5 5 Plocation Bellaire Sugarland Houston Stafford Houston Stafford Dlocation Houston Stafford Bellaire 4 Sugarland Houston Dnum 5 5 5 4 1 4 Bdate 1986-04-05 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 1988-12-30 Daughter Spouse 1967-05-05 Relationship Daughter
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Procedures in SQL
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 System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS