Assume that you have been given the task of compiling evaluations of vendors made by your company’s purchasing agents. Each month, every purchasing agent evaluates all of the vendors that he or she has worked with in the past month on three factors:

price, quality, and responsiveness. Assume the ratings are from 1 to 5, with 5 being the best. Because your company has hundreds of vendors and dozens of purchasing agents, you decide to use Access to compile the results.

a. Create a database with three tables: VENDOR

(VendorNumber, Name, Contact), PURCHASER

(EmpNumber, Name, Email), and RATING

(EmpNumber, VendorNumber, Month, Year, Price Rating, QualityRating, ResponsivenessRating). Assume that VendorNumber and EmpNumber are the keys of VENDOR and PURCHASER, respectively. Decide what you think is the appropriate key for RATING.

b. Create appropriate relationships.

c. Go to this text’s companion Web site and import the data in the Excel file CE10Ex01_E7e. Note that data for VENDOR, PURCHASER, and RATING are stored in three separate worksheets.

d. Create a query that shows the names of all vendors and their average scores.

e. Create a query that shows the names of all employees and their average scores. Hint: In this and in part

f, you will need to use the Group By function in your query.

f. Create a parameterized query that you can use to obtain the minimum, maximum, and average ratings on each criterion for a particular vendor. Assume you will enter VendorName as the parameter.

g. Using the information created by your queries, what conclusions can you make about vendors or purchasers?