Branch branchNo street city postcode BO05 22 Deer Rd London SWI 4EH BO07 16 Argyll St 163 Main StGlasgow Aberdeen AB2 3SU вооз GI1 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 BO05 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 Relation Relation

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter10: Application Development
Section: Chapter Questions
Problem 9VE
icon
Related questions
Question
100%

Drag and drop the proper terms 

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

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Types of Loop
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
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
A+ Guide To It Technical Support
A+ Guide To It Technical Support
Computer Science
ISBN:
9780357108291
Author:
ANDREWS, Jean.
Publisher:
Cengage,
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning