Zip Shuttle Service operates airport shuttle vans in 12 large cities: Los Angeles, San Diego, San Francisco, Phoenix, Las Vegas, Houston, Dallas, Chicago, New York City, Washington DC, Miami, and Orlando. Zip operates passenger vans to shuttle travelers to and from the airports for a $25 fee per person.

Required:

a. Design the tables that the company would need in its database to operate these shuttles. Remember that they must collect, record, and track information about customers, payments, flights, gates, vans, drivers, and pick‐up and delivery addresses. You may wish to add other types of data. The tables you design should have attributes (columns) for each critical piece of data. See Exhibit 13‑4 for the concept of the table layouts. Your tables should meet the first three rules of data normalization.

b. Describe the advantages and disadvantages for Zip of using a centralized database as opposed to a separate database for each location.