The project we are going to build is a booking application for the Oakbridge Community Center. Most recreation centers rely on a face-to-face or telephone booking systems for their facilities. Realizing their membership is quite technologically literate, they have decided to offer online booking of the various sports facilities, meeting rooms, and public recreational and entertainment activities undertaken by the community center. To the uninitiated, this project could be a rather daunting prospect. In fact, it is rather uncomplicated. Our approach was to use a date book metaphor. By segmenting a day into hourly increments during the center's business hours, we could visualize what needed to be done. To actually see what we were talking about, we created the layout in Freehand MX. We imported the .png file used for the home page in Chapter 10 into Freehand MX. We then created the time strips by using the Rectangle tool and duplicated it nine times to recreate a ten- hour day. The result is shown in Figure 13.1. Figure 13.1. The booking facility starts out as a visualization exercise in Freehand MX.
After we knew what it would look like, we started planning the data. The question was, "What data do we need for the date book?" Obviously, we needed to identify which facility was being booked. We needed to identify who booked the facility. We also needed to know the duration of the booking and when the booking was needed. With that information in hand, we had to put it into terms the database would understand. This required an addition to the data dictionary developed for the tour, as shown in Figure 13.2. As you can see, a new table named "bookings" is created. It will be composed of four fields:
Figure 13.2. The Oakbridge data dictionary is updated to reflect the addition of a booking table to the database.
Note The data dictionary shown is available for download from the book's web site. It is a .pdf file named Booking. |