The Northwinds database has several tables, including Products, Suppliers, and Categories.

A subset of the Products table is provided, which details all the products that a fictional company named Northwinds sells. The Northwinds database is generously provided by Microsoft as an example database. It is not necessary for you to open the database to answer this question. The subset of the Products table provided below will give you enough information. However, if you would like to dive into the full database, you can open Microsoft Access and search the templates for Northwinds to download it.

a. Glancing through each variable in the Products table, which stand out as numerical data, that is, data that would be interesting to add or average?

b. If you averaged everything in the SupplierID field, would you obtain a useful number?

c. If you averaged UnitPrice, would you obtain a useful number?

d. What does the field SupplierID represent? Is it categorical or numerical?

e. Which fields should you use to calculate when it’s time to reorder a product?

f. If you were to create a meaningful report regarding when products should be reordered, which fields would you include? Which fields would you create via numerical calculations? How often would you run the report?

Transcribed Image Text:

ProductID ProductName SupplierID CategoryID QuantityPerUnit Unit Price UnitsInStock Units On Order ReorderLevel Discontinued 1 Chai 10 boxes x 20 24-12 oz 1 1 bags 2 Chang 1 1 bottles 18 19 39 0 10 0 17 17 40 25 0 Aniseed 3 Syrup Chef Anton's Cajun 4 Seasoning 12-550 ml 1 2 bottles 2 2 48 - 6 oz jars 10 113 13 70 25 0 22 22 53 0 0 0