Assume that you have been given the task of compiling evaluations that your company's purchasing agents make of their e-commerce vendors. Each month, every purchasing agent evaluates all of the vendors that he or she has ordered from 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 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. Import the data in the Excel file Ch07Ex02. Note that the 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 data created by your queries, what conclusions can you make about ven-dors or purchasers?
Attachment:- ch07ex02.xlsx