This problem is a continuation of Problem 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.

Transcribed Image Text:

FIGURE 6.12 Linking Two Relations in a Many-to-Many Relationship CLIENT Client_No Name Street_Address City State ZIP_Code Contact Phone_Number CLIENT_EMP Employee_No Client_No EMPLOYEE Employee_No Soc_Sec_No Name Supervisor_No Billing_Rate Pay_Rate