. Consider Figure 4-35 and your answer to Problem and Exercise 4-44 in Chapter 4. Assume that it is essential that customers who had rented from Vacation Property Rentals earlier can be identified quickly based on their last name–first name combination, e-mail, and phone number. Also, assume that the organization needs to be able to sort rental agreements based on their begin date.

The most important criteria for property searches are the property’s zip code and the number of rooms. Develop an indexing solution for this database and discuss how the factors listed above affected your decisions.