A Three-Tier Application

• We will have a single database table, CityZone, with city and time zone names
• If the TimeZoneBean can't find the city among the standard time zone IDs, it makes a query:

  SELECT Zone FROM CityZone WHERE City = the requested city

• If there is a matching entry in the database, that time zone is returned