Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ethical Obligations And Decision Making In Accounting Text And Cases

Authors: Steven Mintz

6th Edition

1264135947, 9781264135943

More Books

Students also viewed these Accounting questions

Question

2. To store it and

Answered: 1 week ago