Draw the ER-diagram to represent the system described in The EasyDrive School of Motoring Case Study The EasyDrive.

Draw the ER-diagram to represent the system described in The EasyDrive School of Motoring Case Study The EasyDrive. Using the ER-diagram produce a distributed database design for the system, and include

A suitable fragmentation schema for the system.

In the case of primary horizontal fragmentation, a minimal set of predicates.

The reconstruction of global relations from fragments.

State any assumptions necessary to support your design.