5. Assume you have been given the task of compiling evaluations that your company’s purchasing agents make of their vendors. 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, PriceRating, QualityRating, ResponsivenessRating). Assume 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 using Tools/Relationships.

c. Using the table view of each table, enter sample data for vendors, employees, and ratings.

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 question

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