Using the Crows foot model, create the conceptual model (i.e. ER Diagram) of a Charter Database using the business rules provided below.

Joes SkyTour Inc. is a helicopter tour and sightseeing company in Maui, Hawaii. The company owns helicopters that are used to fly tourists over the Maui Island for sightseeing. The company has created a database to track the helicopters it owns, including each helicopters unique ID number, name, model, seating capacity, average cost per hour used, and the date it was last maintained. The database also maintains information about each pilot it employs and assigns to fly trips, such as unique pilot ID, Social Security number, first name, last name, street, city, state, zipcode (first 5 digits), phone number, and date of birth. The company offers different types of tours (with different tour durations and cover different sites) for customers to book. Information regarding these tour types, including the unique tour type ID, tour type name, expected tour hours, and ticket price, is also saved in the database. In addition, all information about each trip, including unique trip ID, the ID of the helicopter used, the ID of the pilot taking charge of the trip, the ID of the tour type for the trip, the date the trip takes place, the starting time of trip, and the number of passengers on the trip, is also kept in the database.

Each trip takes only one helicopter, but a helicopter may be used for multiple trips (on different dates/times) or may have not been used for any trip yet. Each particular trip has only one pilot assigned to it, but a pilot may be assigned to different trips (on different dates/times) or may have not been assigned to any trip yet. Each trip belongs to one particular tour type, but a specific tour type may be chosen for different trips or may have not been chosen by any trip.