Please include propr ER Diagram Drawing that is clearly labeled. And Database Design Outline in this format:

omplete the database design outline, like such ex) for a flight:

FLIGHT(FlightNumber, OriginAirport, DepartureTime, DestinationAirport, ArrivalTime) FLIESONDAY(FlightNumber, Day, PlaneCode) FlightNumber foreign key to FLIGHT PlaneCode foreign key to KINDOFPLANE KINDOFPLANE(PlaneCode, FullPlaneName, SeatingCapacity)

For each of the following problems, design an appropriate database (drawing an ER diagram and writing a database design outline). In each question below, assume that any address information specified is in US format, consisting of fields for street address, city, two-letter state code, and zip code. Unless stated otherwise in an individual problem, assume that you do not have the master zip code table in your databases, so that city, state, and zip code may be treated as independent. When the problems specify that you should store a date/time, assume that you will store dates and times together in one field, which are able to store a date and time together in a single attribute. 1. 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 operated by employees, for each of whom you want to store an employee number, first name, last name, date of birth, date hired, cell phone number, home phone number, and address information. The employees use the boats to visit various sites around the harbor. Each site has a site number, name, and description. Each instance of a boat leaving 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 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; in general, the agency tries to visit each site at least once every few days. You want to record the set of sites visited by each patrol, and the exact date and time of each visit. Design a database to store this information. Draw an ER diagram, and write a database design outline. You may add ID fields where necessary