ABC Supplier Inc has Distribution/Data Centers in MSP, SFO. and NYC and head qua
ID: 3838205 • Letter: A
Question
ABC Supplier Inc has Distribution/Data Centers in MSP, SFO. and NYC and head quarters in MSP Consider the following global schema currently located In MSP Assuming that most of the queries will be based on Suppliant, design a horizontal fragmentation scheme for each of the THREE DCs. Change the table structures and enter no more than two example rows for each of the THREE DCs. a) MSP DC New Design Supplier Supply Parts b) SFO DC New Design Supplier Supply Parts c) NYC DC New Design Supplier Supply PartsExplanation / Answer
5a) MSP DC New Design
Supplier
Supply
Parts
5a) SFO New Design
Supplier
Supply
Parts
5a) NYC DC New Design
Supplier
Supply
Parts