|
|
|
You,
the students, will be working in teams of three to compile data
for a database. The team will research 60 cars to create a database.
The information about these 60 cars will be kept in 3 tables of the team's
design. Once the team has the tables completed, each member of the
team will design a query that, when a customers specifications are entered,
will return to the customer a car or cars that meet those specifications.
When the three queries are done, the students get together to explain their
queries to the other members of the team. The team chooses a best
query or modifies a query to include the best ideas. The team then
creates a form for the customer to use when they request the database service,
and a report is the result of the query for the customer to review.
The database, when finished will allow a consumer to request a report of
a car that meets his or her needs for a car.
The Tables. Your database will have three tables: one for SUVs (Jeeps and Explorers) and trucks, one for sportscars (Corvettes and Miatas and such), and one for other cars (other sedans, coupes or station wagons). Each table will have the following fields: model of the car, manufacturer, cost of the vehicle, uses for that particular kind of automobile, safety ratings, reliability ratings, features, and national origin of manufacturer. The team members will divide the the responsibility of data collection as they wish, and combine their data to create the three tables. Each field must have a validation rule and validation text for the data!
The Query. Your query will be interactive.
When the consumer or user uses your database, he or she will enter the
criteria for an ideal car (all fields will be used) and the query must
return a car from the database based on the consumer's criteria. If, for
instance, the consumer wants a cheap vehicle for offroad use, the query
might return all the SUVs with a cost of less than $6000.00. The Report. The report takes the results of the query and produces them in a nice graphical form. The user should receive an easy-to-read document that gives them the model, manufacturer, prices, safety rating and reliability rating of the recommended car or cars.
|
