Answered step by step
Verified Expert Solution
Question
1 Approved Answer
P 2-3 (LO 2.3) Northwind Traders is a fictitious specialty foods company... Northwind Traders is a fictitious specialty foods company created by Microsoft, which has
P 2-3 (LO 2.3) Northwind Traders is a fictitious specialty foods company... 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. Below is a subset of the Products table, which details all the products that Northwind Traders sells. ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevelDiscontinued 10 boxes x 20 Chai bags 18 39 0 10 0 24 - 12 oz Chang 1 1 bottles 19 17 40 25 0 12 - 550 ml Aniseed Syrup 1 2 bottles 10 13 70 25 0 Chef Anton's Cajun Seasoning 2 2 48 - 6 oz jars 22 53 0 0 0 Required: a. Is the Supplier ID field categorical or numerical? The Supplier ID field is Numericalb. Which two fields in this table are foreign keys? Note: You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect. ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel . . . . . Discontinued
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started