MIS homework
MIS 3003 Chapter 8 Homework
Assume that 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 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. (3pts.)
b. Create appropriate relationships. (1pt)
c. Import the data in the Excel file Ch08Ex02_U7e.xlsx. Note that data for Vendor, Purchaser, and Rating are stored in three separate worksheets. (1pt.)
d. Create a query that shows the names of all vendors and their average scores. Hint: In this and in part e, you will need to use the Group By function in your query. (2pts.)
e. Create a query that shows the names of all employees and their average scores. (2pts.)