Which of the following columns acts as a foreign key? Employee EmployeelD EmpName DeptNo Salary Address St Address Zip 151234 Jones, Ted MGMT 47 555 Smith St 10001 241504 Smith, Jane CS 101 099 Post Ave 07071 310927 Kool, Bl MATH 68 56 Sherwood Ave 07032 428541 Lan, Jackie IS 93 1313 Mockingbird Ln 86051 529624 Witt, Stu CHE 75 1776 Freedom Way 07453 629632 Kahn, Fran CS 65 214 Valentine Court 07402 472285 Johnson, Bob IS 78 123 Schuyler Street 07417 Department DeptID DeptName Management Phone MGMT 973)555-1234 (973)555-1287 (973)555-1455 CS Computer Science MATH Math IS Information Systems (973)555-1238 Chemical Engineering CHE (973)555-1239 O Employee.Salary O Employee EmpName O Employee EmployeelD O Department DeptID Employee DeptNo

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
icon
Related questions
Question
Please Help ASAP!!!
Which of the following columns acts as a foreign key?
Employee
EmployeelD
EmpName
DeptNo
Salary
Address St
Address Zip
151234
Jones, Ted
MGMT
47
555 Smith St
10001
241504
Smith, Jane
cs
101
999 Post Ave
07071
310927
Kool, BI
MATH
68
55 Sherwood Ave
07032
428541
Lan, Jackle
is
93
1313 Mockingbird Ln
86051
529624
Witt, Stu
CHE
75
1776 Freedom Way
07453
629632
Kahn, Fran
cs
65
214 Valentine Court
07402
472285
Johnson, Bob
IS
78
123 Schuyler Street
07417
Department
DeptID DeptName
Management
Phone
MGMT
973)555-1234
Computer Science (973)555-1287
cs
MATH
Math
(973)555-1455
IS
Information Systems (973)555-1238
CHE
Chemical
(973)555-1239
Engineering
O Employee.Salary
O Employee.EmpName
O Employee.EmployeelD
O Department DeptID
O Employee DeptNo
Transcribed Image Text:Which of the following columns acts as a foreign key? Employee EmployeelD EmpName DeptNo Salary Address St Address Zip 151234 Jones, Ted MGMT 47 555 Smith St 10001 241504 Smith, Jane cs 101 999 Post Ave 07071 310927 Kool, BI MATH 68 55 Sherwood Ave 07032 428541 Lan, Jackle is 93 1313 Mockingbird Ln 86051 529624 Witt, Stu CHE 75 1776 Freedom Way 07453 629632 Kahn, Fran cs 65 214 Valentine Court 07402 472285 Johnson, Bob IS 78 123 Schuyler Street 07417 Department DeptID DeptName Management Phone MGMT 973)555-1234 Computer Science (973)555-1287 cs MATH Math (973)555-1455 IS Information Systems (973)555-1238 CHE Chemical (973)555-1239 Engineering O Employee.Salary O Employee.EmpName O Employee.EmployeelD O Department DeptID O Employee DeptNo
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Linux
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