Database Reference
In-Depth Information
DATABASE - Employee Relation
EmpNo
123
234
Name
City
Position
Dept
Salary
Bolton
Reno
Programmer
Info Tech 65000
Watkins
Houston Manager
Sales
70000
New York
DATABASE - Employee Relation
EmpNo
345
456
901
Name
City
Position
Dept
Salary
Harvey
London Analyst
Finance
69000
Dillon
Dublin
Programmer
Info Tech 60000
Foster
Norfolk Analyst
Info Tech 86000
London
DATABASE - Employee Relation
EmpNo
567
678
789
Name
City
Position
Dept
Salary
Ceccatelli Milan
Vice President Marketing 110000
Bertolini
Firenze Manager
Finance
85000
Milan
Galileo
Turin
Vice President R & D
125000
Figure 18-10
EMPLOYEE relation: horizontal fragmentation.
DATABASE - Employee Relation
TupleID
t1
t2
t3
t4
t5
t6
t7
t8
EmpNo
123
234
345
456
567
678
789
901
Name
Dept
Salary
Bolton
Info Tech
65000
70000
69000
60000
110000
85000
125000
86000
Watkins
Sales
Harvey
Finance
New York
Dillon
Info Tech
Ceccatelli
Marketing
Bertolini
Finance
Galileo
R & D
Foster
Info Tech
DATABASE - Employee Relation
TupleID
t1
t2
t3
t4
t5
t6
t7
t8
EmpNo
123
234
345
456
567
678
789
901
Name
City
Position
Dept
Bolton
Reno
Programmer
Info Tech
Watkins
Houston Manager
Sales
Harvey
London
Analyst
Finance
Boston
Dillon
Dublin
Programmer
Info Tech
Ceccatelli
Milan
Vice President
Marketing
Bertolini
Firenze
Manager
Finance
Galileo
Turin
Vice President
R & D
Foster
Norfolk
Analyst
Info Tech
Figure 18-11
EMPLOYEE relation: vertical fragmentation.
Search WWH ::
Custom Search