Task $1$: Distributed Database Design $(30\%)$ Happy Cruise Lines is a cruise company with several ships and a variety of cruise itineraries, each involving several ports of call. The company headquarters is in New York and has regional offices in the cruise port cities of Miami, Houston, and Los Angeles.

The company maintains information on ships, cruises, ports, passengers and voyages. CRUISE is a particular sailing of a ship on a particular date. VISITS records the ships visits to the ports during the cruise. VOYAGE records the passengers for a cruise. Given below is the snapshot of Happy Cruise Lines$$ database which lists the attributes for each entity along with the primary key and foreign keys.

SHIPS: $($SHIPNUM$,$ SHIPNAME, BUILDER, LAUNCHDATE, WEIGHT$)$ PASSENGER: $($PASSENGERNUM$,$ PASSENGERNAME, SOCIALSECNUM, STATE, COUNTRY$)$

PORT: $($PORTNUM$,$ COUNTRY, NUMDOCKS, MANAGER$)$

CRUISE: $($CRUISENUM$,$ STARTDATE, ENDDATE, DIRECTOR, SHIPNUM$)$ VISIT: $($CRUISENUM$,$ PORTNUM, COUNTRY, ARRDATE, DEPTDATE$)$ VOYAGE: $($PASSENGERNUM$,$ CRUISENUM, ROOMNUM, FARE$)$

SHIPS: The Company has $20$ ships and the details of these ships are used in every office. CRUISE: There are around $4000$ cruise records; cruise records are used most heavily in the cities from which the cruise described in the record began.

PORT: There are $42$ records in the port table. The records describe Atlantic Ocean ports that are used most heavily in New York and Miami. The records that describe Caribbean Seaports are used most heavily in Houston and Miami. The records that describe Pacific Ocean ports are used most heavily in Los Angeles.

VISIT: Consists of $15,000$ records and is primarily used in the New York $($headquarters$)$ and Los Angeles.

PASSENGER: Consists of $230,000$ records and is primarily used in New York $($headquarters$)$ and Los Angeles offices.

VOYAGE: Consists of $720,000$ records and is used in all four offices. Design a data distribution scheme in line with your solution