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
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
Related questions
Question
a) Referring to the company
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.
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
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education