The Northwinds database has several tables, including Products, Suppliers, and Categories. A subset of the Products...

  

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

a Glacing through each variablein the products tablewhich stadout as numerical data t... View the full answer