Question
Match the data fragmentation method shown to the proper strategy name: Table name: Vehicles License Owner Make Model Year Value Cylinders ABC333 J. Jones Volvo
Match the data fragmentation method shown to the proper strategy name:
Table name: Vehicles
| License | Owner | Make | Model | Year | Value | Cylinders |
| ABC333 | J. Jones | Volvo | 240 | 1993 | 2300 | 4 |
| BGF678 | A. Ames | Ford | Tarus | 2010 | 13000 | 6 |
| HJK431 | A. Ames | Jaguar | XJ6 | 2013 | 27000 | 6 |
| PJH680 | K. Karsen | Kia | Sorrento | 2014 | 15000 | 4 |
| LLL987 | M. Andretti | Chevrolet | Volt | 2014 | 37500 | 4 |
The data will be fragmented by three different methods:
Method A)
Table name: VEH_F1 Topeka KS Node: TPK
| License | Year | Value | Cylinders |
| ABC333 | 1993 | 2300 | 4 |
| BGF678 | 2010 | 13000 | 6 |
| HJK431 | 2013 | 27000 | 6 |
| PJH680 | 2014 | 15000 | 4 |
| LLL987 | 2014 | 37500 | 4 |
Table name: VEH_F2 Columbus OH Node: COL
| License | Owner | Make | Model |
| ABC333 | J. Jones | Volvo | 240 |
| BGF678 | A. Ames | Ford | Tarus |
| HJK431 | A. Ames | Jaguar | XJ6 |
| PJH680 | K. Karsen | Kia | Sorrento |
| LLL987 | M. Andretti | Chevrolet | Volt |
Method B)
Table name: VEH_F1 Topeka KS Node: TPK
| License | Owner | Make | Model |
| ABC333 | J. Jones | Volvo | 240 |
| PJH680 | K. Karsen | Kia | Sorrento |
| LLL987 | M. Andretti | Chevrolet | Volt |
Table name: VEH_F2 Topeka KS Node: TPK
| License | Year | Value | Cylinders |
| ABC333 | 1993 | 2300 | 4 |
| PJH680 | 2014 | 15000 | 4 |
| LLL987 | 2014 | 37500 | 4 |
Table name: VEH_F3 Columbus OH Node: COL
| License | Year | Value | Cylinders |
| BGF678 | 2010 | 13000 | 6 |
| HJK431 | 2013 | 27000 | 6 |
Table name: VEH_F4 Columbus OH Node: COL
| License | Owner | Make | Model |
| BGF678 | A. Ames | Ford | Tarus |
| HJK431 | A. Ames | Jaguar | XJ6 |
Method C)
Table name: VEH_F1 Topeka KS Node: TPK
| License | Owner | Make | Model | Year | Value | Cylinders |
| ABC333 | J. Jones | Volvo | 240 | 1993 | 2300 | 4 |
| PJH680 | K. Karsen | Kia | Sorrento | 2014 | 15000 | 4 |
| LLL987 | M. Andretti | Chevrolet | Volt | 2014 | 37500 | 4 |
Table name: VEH_F2 Columbus OH Node: COL
| License | Owner | Make | Model | Year | Value | Cylinders |
| BGF678 | A. Ames | Ford | Tarus | 2010 | 13000 | 6 |
| HJK431 | A. Ames | Jaguar | XJ6 | 2013 | 27000 | 6 |
Match the data fragmentation method shown to the proper strategy name:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started