Note: This problem is a continuation of Problem 6-3 but requires use of a spreadsheet pa...

Note: This problem is a continuation of Problem 6-3 but requires use of a spreadsheet package that is capable of reading data from your database package (e.g., Excel can import data from an Access database).

a. Using your spreadsheet package, construct SQL queries (or use the software’s menu generation for queries) to import the billing information for Fleet Services.

b. Develop a report format for using the information from your queries to generate a nice-looking report in your spreadsheet package.

c. Document the queries used in your spreadsheet package to access the data and explain what each step of the queries does.

Problems 6-3

Using the information from Figure 6.12 (pg. 203) and Figure 6.13 create the database in the software package of your choice. This will require three steps:

• Implement the relations from Figure 6.13.

• Insert the data from Figure 6.13 into the relational tables.

• Print the data from each of the relations to test for successful implementation.