Case Study 5 - Rapid Roads
A haulage company called Rapid Roads specializes in the transportation of loads throughout the UK and Europe. Rapid Roads has many offices throughout the UK and Europe to process customer orders and has decided to distribute its operations according to these countries. The company also proposes to distribute staff details to the appropriate countries, however staff payroll details will be processed by the Head Office of Rapid Roads, which is located in the UK.
The offices of Rapid Roads are grouped into countries as follows:
Country 1 (C1): UK $\quad$Country 4 (C4): Switzerland
Country 2 (C2): France $\quad$Country 5 (C5): Spain
Country 3 (C3): Germany $\quad$ Country 6 (C6): Italy
-(a) Draw an Entity-Relationship Diagram for the above case study.
(b) Using this diagram from (a) above, produce a distributed database design for the system that satisfies the correctness rules for fragmentation and include:
(I) a suitable fragmentation schema for the system;
(ii) in the case of primary horizontal fragmentation, give a minimal set of predicates;
(iii) the reconstruction of global relations from fragments.
Give a full explanation of the reasoning behind each step and state any assumptions necessary to support your design.

Question

Case Study 5 - Rapid Roads
A haulage company called Rapid Roads specializes in the transportation of loads throughout the UK and Europe. Rapid Roads has many offices throughout the UK and Europe to process customer orders and has decided to distribute its operations according to these countries. The company also proposes to distribute staff details to the appropriate countries, however staff payroll details will be processed by the Head Office of Rapid Roads, which is located in the UK.
  The offices of Rapid Roads are grouped into countries as follows:
Country 1 (C1): UK $\quad$Country 4 (C4): Switzerland
Country 2 (C2): France $\quad$Country 5 (C5): Spain
Country 3 (C3): Germany $\quad$ Country 6 (C6): Italy
-(a)	Draw an Entity-Relationship Diagram for the above case study.
(b) Using this diagram from (a) above, produce a distributed database design for the system that satisfies the correctness rules for fragmentation and include:
(I) a suitable fragmentation schema for the system;
(ii) in the case of primary horizontal fragmentation, give a minimal set of predicates;
(iii) the reconstruction of global relations from fragments.
Give a full explanation of the reasoning behind each step and state any assumptions necessary to support your design.

Quizplus · Accepted Answer

The Answer of Case Study 5 - Rapid Roads
A haulage company called Rapid Roads specializes in the transportation of loads throughout the UK and Europe. Rapid Roads has many offices throughout the UK and Europe to process customer orders and has decided to distribute its operations according to these countries. The company also proposes to distribute staff details to the appropriate countries, however staff payroll details will be processed by the Head Office of Rapid Roads, which is located in the UK.
  The offices of Rapid Roads are grouped into countries as follows:
Country 1 (C1): UK $\quad$Country 4 (C4): Switzerland
Country 2 (C2): France $\quad$Country 5 (C5): Spain
Country 3 (C3): Germany $\quad$ Country 6 (C6): Italy
-(a)	Draw an Entity-Relationship Diagram for the above case study.
(b) Using this diagram from (a) above, produce a distributed database design for the system that satisfies the correctness rules for fragmentation and include:
(I) a suitable fragmentation schema for the system;
(ii) in the case of primary horizontal fragmentation, give a minimal set of predicates;
(iii) the reconstruction of global relations from fragments.
Give a full explanation of the reasoning behind each step and state any assumptions necessary to support your design.

Case Study 5 - Rapid Roads a Haulage Company Called \quad

Case Study 5 - Rapid Roads
a Haulage Company Called $\quad$