Question 2. (30 points) You have been assigned the task of automating the records of the Jersey Harbor Patrol Agency. This agency sends patrol boats throughout the Jersey Harbor area, checking for safety and security problems. The agency owns a fleet of boats, for each boat, you want to store its (unique) marine registration number, name, date built, and date acquired. The boats are used by employees for patrolling various sites around the harbor. For each employee you want to store an employee number, first name, last name, date of birth, date hired, cell phone number, home phone number, street address, city, state, and zipcode. Assume you do not have access to zipcode table. Each site has a "site number, name, and description. Each time a boat leaves the agency's home dock is called a "patrol". Each patrol involves two employees, a "captain" and an assistant". The captain is responsible for all decisions on the patrol, and the assistant must follow his or her orders. However, an employee who is the captain of one patrol might be the assistant on a different patrol. For each patrol, you want to record which boat was involved, who the captain and assistant were, what date and time the patrol started, and what date and time it ended. Each patrol involves visits to one or more sites, generally, the agency tries to visit each site at least once every few days. Moreover, some sites can be visited multiple times in each patrol. You want to record the set of sites visited by each patrol, and the exact date and time each visit. Draw an entity-relationship diagram and write a database design outline for a database appropriate for this information