Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Northwinds database has several tables, including Products, Suppliers, and Categories. A subset of the Products table is provided, which details all the products
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. ProductID ProductName SupplierID CategoryID QuantityPerUnit UnitPrice Units InStock UnitsOnOrder ReorderLevel Discontinued 10 boxes x 20 1 Chai 1 1 bags 18 39 0 10 0 24-12 oz 2 Chang 1 19 17 40 25 0 1 10 13 70 25 0 2 22 53 0 0 Aniseed 3 Syrup Chef Anton's Cajun 4 Seasoning 1 bottles 12 - 550 ml 2 bottles 2 48-6 oz jars f-Part 1. If you were to create a meaningful report regarding when products should be reordered, which fields would you include? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answers and double click the box with the question mark to empty the box for a wrong answers. Any boxes left with a question mark will be automatically graded as incorrect.) ProductName ReorderLevel UnitsInStock Supplier D Units OnOrder UnitPrice f-Part 2. Which fields would you create via numerical calculations? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answers and double click the box with the question mark to empty the box for a wrong answers. Any boxes left with a question mark will be automatically graded as incorrect.) ProductName Supplier D CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued
Step by Step Solution
★★★★★
3.44 Rating (170 Votes )
There are 3 Steps involved in it
Step: 1
a Glacing through each variablein the products tablewhich stadout as numerical data t...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