I. Using the Crow's foot model, create the conceptual model (i.e. ER Diagram) of a Charter Database using the business rules provided below. Keep in mind that the same developed conceptual model will be converted into a physical model next week using a database software. Feel free to use any flowcharting software or do it by hand and scan it.

Joe's 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 helicopter's 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.

II. Using the Crow's foot model, make a conceptual model (i.e. ER Diagram) for a real estate firm that lists property for sale. The following describes this organization:

The firm has a number of sales offices in several states. Attributes of sales office include Office_Number (identifier) and Location.Each sales office is assigned one or more employees. Attributes of Employee include Employee_ID (identifier) and Employee_Name. An employee must be assigned to only one sales office. For each sales office, there is always one employee assigned to manage that office. An employee may manage only the sales office to which she is assigned. The firm lists property for sale. Attributes of property included Property_ID (identifier) and Location. Components of Location include Address, City, State, and Zip_Code. Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed, or may have no properties listed. Each unit of property has one or more owners. Attributes of owners are Owner_ID (identifier) and Owner_Name. An owner may own one or more units of property. An attribute of the relationship between property and owner is Percent_Owned.