Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories. Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells.

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

b. Which two fields in this table are foreign keys? Explain.

Transcribed Image Text:

Product Name SupplierID CategoryID QuantityPerUnit UnitPrice Units InStock Units OnOrder ReorderLevel Discontinued 10 boxes x 20 Chai Chang Aniseed Syrup Chef Anton's Cajun Seasoning 1 1 1 2 1 bags 24 - 12 oz 1 bottles 12- 550 ml 2 bottles 2 48-6 oz jars 18 19 10 22 39 17 13 53 0 40 70 0 10 25 25 0 0 0 0