Identify the relational keys in the following two tables. Branch branchNo street city postcode 22 Deer Rd 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow GI1 9QX |32 Manse Rd Bristol 56 Clover Dr London NW10 6EU BO05 |London sW1 4EH BO07 BO03 BS99 INZ B004 BO02 Staff staffNo fName IName position sex DOB salary branchNo White Manager 30000 BO05 10-Nov-60 12000 BO03 24-Mar-58 18000 SL21 John M 1-Oct-45 SG37 Ann Веech Assistant David Ford Supervisor M SG14 BO03 SA9 Mary Howe Assistant 19-Feb-70 9000 BO07 SG5 Brand Manager F 3-Jun-40 24000 9000 BO05 Susan B003 SL41 Julie Lee Assistant 13-Jun-65 Tabel Superkey Candidate Primary Key Alternate Foreign Key Key Keys Branch Staff
Identify the relational keys in the following two tables. Branch branchNo street city postcode 22 Deer Rd 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow GI1 9QX |32 Manse Rd Bristol 56 Clover Dr London NW10 6EU BO05 |London sW1 4EH BO07 BO03 BS99 INZ B004 BO02 Staff staffNo fName IName position sex DOB salary branchNo White Manager 30000 BO05 10-Nov-60 12000 BO03 24-Mar-58 18000 SL21 John M 1-Oct-45 SG37 Ann Веech Assistant David Ford Supervisor M SG14 BO03 SA9 Mary Howe Assistant 19-Feb-70 9000 BO07 SG5 Brand Manager F 3-Jun-40 24000 9000 BO05 Susan B003 SL41 Julie Lee Assistant 13-Jun-65 Tabel Superkey Candidate Primary Key Alternate Foreign Key Key Keys Branch Staff
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
please answer in complete answer please

Transcribed Image Text:Identify the relational keys in the following two tables.
Branch
branchNo street
city
postcode
SWI 4EH
16 Argyll St Aberdeen AB2 3SU
163 Main St Glasgow GI1 9QX
BS99 INZ
NW10 6EU
BO05
22 Deer Rd
London
BO07
B003
BO04
32 Manse Rd Bristol
BO02
56 Clover Dr London
Staff
staffNo fName IName position
sex DOB
salary branchNo
SL21
John
White Manager
M
1-Oct-45
30000
BO05
SG37
Ann
Beech
Assistant
F
10-Nov-60 12000
BO03
SG14
David
Ford
Supervisor M
24-Mar-58 18000
BO03
SA9
Mary
Howe
Assistant
F
19-Feb-70
9000
BO07
SG5
Susan
Brand Manager
F
3-Jun-40
24000
BO03
SL41
Julie
Lee
Assistant
F
13-Jun-65
9000
BO05
Tabel
Superkey
Candidate
Primary Key
Alternate
Foreign Key
Key
Keys
Branch
Staff
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 4 steps with 1 images

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON

Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education

Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY