Consider again the following relational database for the GreenZoo case. ENCLOSURE *EnclosureNumber Location Size Type Date Built ANIMAL *AnimalNumber Species AnimalName Weight Gender Country Of Birth EnclosureNumber ZOOKEEPER *EmployeeNumber EmployeeName Title Year Hired SupervisorNumber CARE *AnimalNumber *Employee Number Service Type *Date *Time GreenZoo now has branches in four cities: Miami (also the Zoo's headquarters), Tucson, Detroit, and Cleveland. The database structure remains the same except that the Location attribute of the ENCLOSURE relation now indicates in which of the four cities the enclosure is located. GreenZoo has decided to reconfigure its database as a distributed database among its four locations. Distributed and replicated among these four locations, the tables have the following characteristics: A) ENCLOSURE consists of 10,000 records and is used most heavily in the cities in which the individual enclosures are located. B) ANIMAL consists of 50,000 records. The entire table is used in the Miami headquarters, in addition to which the records concerning individual animals are used frequently in the locations at which the animals are housed. C) ZOOKEEPER has a huge number of volunteers, and has situation similar to the ANIMAL table. Design a distributed relational database for GreenZoo. Specify your design of data deployment placement, partitioning (H. P. and how), duplication, and/or any combination of these methods for ENCLOSURE, ANIMAL, and ZOOKEEPER (using a data deployment matrix). (3.5 point) Consider again the following relational database for the GreenZoo case. ENCLOSURE *EnclosureNumber Location Size Type Date Built ANIMAL *AnimalNumber Species AnimalName Weight Gender Country Of Birth EnclosureNumber ZOOKEEPER *EmployeeNumber EmployeeName Title Year Hired SupervisorNumber CARE *AnimalNumber *Employee Number Service Type *Date *Time GreenZoo now has branches in four cities: Miami (also the Zoo's headquarters), Tucson, Detroit, and Cleveland. The database structure remains the same except that the Location attribute of the ENCLOSURE relation now indicates in which of the four cities the enclosure is located. GreenZoo has decided to reconfigure its database as a distributed database among its four locations. Distributed and replicated among these four locations, the tables have the following characteristics: A) ENCLOSURE consists of 10,000 records and is used most heavily in the cities in which the individual enclosures are located. B) ANIMAL consists of 50,000 records. The entire table is used in the Miami headquarters, in addition to which the records concerning individual animals are used frequently in the locations at which the animals are housed. C) ZOOKEEPER has a huge number of volunteers, and has situation similar to the ANIMAL table. Design a distributed relational database for GreenZoo. Specify your design of data deployment placement, partitioning (H. P. and how), duplication, and/or any combination of these methods for ENCLOSURE, ANIMAL, and ZOOKEEPER (using a data deployment matrix). (3.5 point)