data distribution

This is the grading requirements and attached below is the hw 

1.Fragmentation strategy-Rationale for fragmentation choices is clearly tied to the facts in the business case. considerations for horizontal, vertical and mixed approaches were explored.

2.Replication strategy-Replication choices are clearly linked to business needs. If no replication is recommended, the reasons why are discussed

3. Schema-The schema is complete, well organized and consistent with all aspects of the fragmentation/replication strategy

4.Distributed transaction-Example transaction is complete and shows an understanding of a 2-phase commit protocol. The approach would keep distributed/replicated data consistent