Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
a) Referring to the company database, which relations have the same set of attributes for their default superkey and primary key? b) Referring to the company database, which relations have a reasonable candidate key that is not its primary key? C) Referring to the company database, specify an update operation to the department relation that will violate a primary key constraint constraint. D) Referring to the company database, what constraints to the database would be violated if Smith were deleted from the employee relation? Include the relevant relations and attributes in your answer.

a) Referring to the company database, which relations have the same set of attributes for their default superkey and primary key? b) Referring to the company database, which relations have a reasonable candidate key that is not its primary key? C) Referring to the company database, specify an update operation to the department relation that will violate a primary key constraint constraint. D) Referring to the company database, what constraints to the database would be violated if Smith were deleted from the employee relation? Include the relevant relations and attributes in your answer.

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

a) Referring to the company database, which relations have the same set of attributes for their default superkey and primary key?

b) Referring to the company database, which relations have a reasonable candidate key that is not its primary key?

C) Referring to the company database, specify an update operation to the department relation that will violate a primary key constraint constraint.

D) Referring to the company database, what constraints to the database would be violated if Smith were deleted from the employee relation? Include the relevant relations and attributes in your answer.

EMPLOYEE Fname Minit Lname Bdate Address Sex Super_ssn Dno Salary 30000 333445555 5 John B Smith Franklin T Wong Ssn 123456789 1965-01-09 731 Fondren, Houston, TX M 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX 43000 888665555 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX James E Borg 888665555 1937-11-10 450 Stone, Houston, TX F 4 38000 333445555 5 25000 333445555 5 25000 987654321 4 55000 NULL 1 DEPARTMENT Dname Research Administration Headquarters WORKS ON Essn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Pno 1 2 3 1 Dnumber 5 4 1 2 NN- 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_ssn 333445555 987654321 888665555 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 DEPENDENT Essn PROJECT Reorganization 19393 Newbenefits 333445555 333445555 333445555 Joy 987654321 123456789 123456789 123456789 Pnumber 1 2 3 Computerization 10 20 30 ProductX ProductY ProductZ Pname Dependent_name Sex F M F M Alice Theodore Abner M F M M Michael Alice Elizabeth DEPT_LOCATIONS Dnumber 1 4 5 5 5 M F F Plocation Bellaire Sugarland Houston Stafford Houston Stafford Dlocation Houston Stafford Bellaire Sugarland Houston Dnum 5 5 5 4 1 4 Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 1988-12-30 Daughter 1967-05-05 Spouse
Transcribed Image Text:EMPLOYEE Fname Minit Lname Bdate Address Sex Super_ssn Dno Salary 30000 333445555 5 John B Smith Franklin T Wong Ssn 123456789 1965-01-09 731 Fondren, Houston, TX M 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX 43000 888665555 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX James E Borg 888665555 1937-11-10 450 Stone, Houston, TX F 4 38000 333445555 5 25000 333445555 5 25000 987654321 4 55000 NULL 1 DEPARTMENT Dname Research Administration Headquarters WORKS ON Essn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Pno 1 2 3 1 Dnumber 5 4 1 2 NN- 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_ssn 333445555 987654321 888665555 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 DEPENDENT Essn PROJECT Reorganization 19393 Newbenefits 333445555 333445555 333445555 Joy 987654321 123456789 123456789 123456789 Pnumber 1 2 3 Computerization 10 20 30 ProductX ProductY ProductZ Pname Dependent_name Sex F M F M Alice Theodore Abner M F M M Michael Alice Elizabeth DEPT_LOCATIONS Dnumber 1 4 5 5 5 M F F Plocation Bellaire Sugarland Houston Stafford Houston Stafford Dlocation Houston Stafford Bellaire Sugarland Houston Dnum 5 5 5 4 1 4 Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 1988-12-30 Daughter 1967-05-05 Spouse
EMPLOYEE Fname Minit Lname Ssn Bdate DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum Address Sex Salary Super_ssn Dno WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship CourseSmart Figure 3.7 Referential integrity constraints displayed on the COMPANY relational database schema.
Transcribed Image Text:EMPLOYEE Fname Minit Lname Ssn Bdate DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum Address Sex Salary Super_ssn Dno WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship CourseSmart Figure 3.7 Referential integrity constraints displayed on the COMPANY relational database schema.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Database Development
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