Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: CREATING THE DATABASE DESIGN
Type
Capacity
Range
Light cabin
7 people
1600 miles
Mid-sized cabin
8 people
3000 miles
Large cabin
10 people
4300 miles
FIGURE 2-1
Types of jets
When a booking comes into Internet Jets, it is displayed like a form is displayed in Microsoft Access. The
booking information shows the type of jet requested, the customer, the origination and destination of the trip,
and the date and time requested. The booking agent at Internet Jets assigns an airplane to each request.
Ignore this step in the process
your design and implementation involve only the reservation requests, not
the actual flights assigned and flown.
The jets are flown by professional pilots, and each flight has a captain and co-captain. Some customers
like certain pilots and want those pilots to fly their plane. In response to that request, the booking form now
includes a space for customers to request a particular pilot. Your form should include a drop-down menu that
lists all the pilots so customers can simply click on their requested pilot. In addition, to avoid any mistakes in
data entry, the form should include a drop-down menu that lists the various types of available airplanes.
Besides the reservation form, management would like you to create a number of queries to show some
important information. First, management wants to know which states that members of the flying cooperative
live in so the company can better market and advertise the service. You suggest a query that will prompt for
the state as an input; management can then use this query to find members in any state.
Management often wants to know the bookings at different times of the year, and has asked you to create
a query that lists the bookings for a particular period of weeks or days. In addition, management is curious
about the popularity of certain aspects of the jet service. They would like to know which airplane size is the
most popular, and which pilots are the most frequently requested.
Finally, management would like to see a report that lists all customers and the reservations they have made.
ASSIGNMENT 1: CREATING THE DATABASE DESIGN
In this assignment, you will design your database tables using a word-processing program. Pay close attention to
the tables
logic and structure. Do not start developing your Access code in Assignment 2 before getting feedback
from your instructor on Assignment 1. Keep in mind that you will need to examine the requirements in
Assignment 2 to design your fields and tables properly. It is good programming practice to look at the required outputs
before beginning your design. When designing the database, observe the following guidelines:
￿
First, determine the tables you will need by listing the name of each table and the fields it
should contain. Avoid data redundancy. Do not create a field if it can be created by a
calculated
field
in a query.
￿
You will need transaction tables. Think about what business events occur with each member
s
actions. Avoid duplicating data.
￿
Document your tables using the table feature of your word processor. Your tables should
resemble the format shown in Figure 2-2.
￿
You must mark the appropriate key field(s) by entering an asterisk (*) next to the field name.
￿
Print the database design if your instructor requires it.
Table Name
Field Name
Data Type (text, numeric, currency, etc.)
FIGURE 2-2
Table design
Search JabSto ::




Custom Search