Branch branchNo street city postcode BO05 22 Deer Rd London SWI 4EH BO07 16 Argyll St Aberdeen AB2 3SU BO03 163 Main St Glasgow GII 9QX B004 32 Manse Rd Bristol BS99 INZ BO02 56 Clover Dr London NW10 6EU Foreign key Staff staffNo fName IName position sex DOB salary branchNo SL21 John White Manager M 1-Oct-45 30000 BO0S SG37 Ann Beech Assistant 10-Nov-60 12000 BO03 SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant 19-Feb-70 9000 BO07 SG5 Susan Brand Manager 3-Jun-40 24000 BO03 SLAI Julie Lee Assistant 13-Jun-65 9000 BO05 Tuple Degree Candidate Key Cardinality Domain Attributes Drag and drop the proper terms Relation Relation

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
Branch
branchNo street
city
postcode
sWI 4EH
16 Argyll St Aberdeen AB2 3SU
GI1 9QX
BO05
22 Deer Rd
London
BO07
BO03
163 Main StGlasgow
BO04
32 Manse Rd Bristol
BS99 INZ
BO02
56 Clover Dr London
NW10 6EU
Foreign key
Staff
staffNo fName IName| position
salary branchNo
sex DOB
SL21
John
White
Manager
Assistant
M
1-Oct-45
30000
BO05
SG37
Ann
Beech
10-Nov-60 12000
вооз
SG14
David
Ford
Supervisor M
24-Mar-58
18000
BO03
SA9
Mary
Howe
Assistant
19-Feb-70
9000
BO07
SG5
Susan
Brand
Manager
3-Jun-40
24000
BO03
SLA1
Julie
Lee
Assistant
13-Jun-65
9000
BO05
Tuple
Degree
Candidate Key
Cardinality
Domain
Attributes
Drag and drop the proper terms
Relation
Relation
Transcribed Image Text:Branch branchNo street city postcode sWI 4EH 16 Argyll St Aberdeen AB2 3SU GI1 9QX BO05 22 Deer Rd London BO07 BO03 163 Main StGlasgow BO04 32 Manse Rd Bristol BS99 INZ BO02 56 Clover Dr London NW10 6EU Foreign key Staff staffNo fName IName| position salary branchNo sex DOB SL21 John White Manager Assistant M 1-Oct-45 30000 BO05 SG37 Ann Beech 10-Nov-60 12000 вооз SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant 19-Feb-70 9000 BO07 SG5 Susan Brand Manager 3-Jun-40 24000 BO03 SLA1 Julie Lee Assistant 13-Jun-65 9000 BO05 Tuple Degree Candidate Key Cardinality Domain Attributes Drag and drop the proper terms Relation Relation
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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