Question: Using AdventureWorks2012 P-5C3MBPH...2012 - Diagram_0% Wardrop RyanAssig...MBPHRWard (65))* Assignment06.sql - not connected + X -3. a. List Products, their subcategories and their categories. Show the

$Using AdventureWorks2012 P-5C3MBPH\...2012 - Diagram_0% Wardrop RyanAssig...MBPH\RWard (65))* Assignment06.sql - not$

connected + X -3. a. List Products, their subcategories and their categories.

Show the category name, subcategory name, product ID, and product name, in

this order. Sort in alphabetical order on category name, then subcategory name,

and then by product name. (1 points) 295 Rows Hint: To understand

the relationshships, refer to your database diagram and the following tables: Production.Product

Using AdventureWorks2012

Production.ProductSubCategory Production. ProductCategory Connect L. Production Product Columns ProductID (PK, int, not

null) Name (Name(nvarchar(50)), r E ProductNumber (nvarchar(25 E MakeFlag (Flag(bit), not null)

FinishedGoodsFlag (Flag(bit), E Color (nvarchar(15), null) SafetyStockLevel (smallint, no ReorderPoint (smallint, not

P-5C3MBPH\...2012 - Diagram_0% Wardrop RyanAssig...MBPH\RWard (65))* Assignment06.sql - not connected + X -3. a. List Products, their subcategories and their categories. Show the category name, subcategory name, product ID, and product name, in this order. Sort in alphabetical order on category name, then subcategory name, and then by product name. (1 points) 295 Rows Hint: To understand the relationshships, refer to your database diagram and the following tables: Production.Product Production.ProductSubCategory Production. ProductCategory Connect L. Production Product Columns ProductID (PK, int, not null) Name (Name(nvarchar(50)), r E ProductNumber (nvarchar(25 E MakeFlag (Flag(bit), not null) FinishedGoodsFlag (Flag(bit), E Color (nvarchar(15), null) SafetyStockLevel (smallint, no ReorderPoint (smallint, not nu StandardCost (money, not nu ListPrice (money, not null) Size (nvarchar(5), null) - SizeUnitMeasureCode (FK, nel - WeightUnitMeasureCode (FK, Weight (decimal(8,2), null) DaysToManufacture (int, not i ProductLine (nchar(2), null) Class (nchar(2), null) Style (nchar(2), null) 6- ProductSubcategory|D (FK, in e ProductModellD (FK, int, null E SellStartDate (datetime, not nu SellEndDate (datetime, null) E DiscontinuedDate (datetime, 1 rowguid (uniqueidentifier, no E ModifiedDate (datetime, not i Keys Constraints Columns e ProductCategory|D (PK, int, n Name (Name(nvarchar(50)), r rowguid (uniqueidentifier, no ModifiedDate (datetime, not 1 Keys Constraints + + Triggers Indexes Statistics Production.ProductCost History Production.ProductDescription Production.ProductDocument Production.ProductInventory Production ProductListPrice History Production.Product Model Production.ProductModellllustration Production.Product ModelProductDe Production.ProductPhoto Production.Product ProductPhoto Production.ProductReview Production.ProductSubcategory Production.ScrapReason Production. Transaction History 1 Production Transaction History Archiv Production.UnitMeasure Production.ProductDescription EB Production.ProductDocument 0 Production.ProductInventory n Production.ProductListPrice History Production.ProductModel Columns o Product ModellD (PK, int, not Name (Name(nvarchar(50)), r CatalogDescription (XML(Pro Instructions (XML(Production rowguid (uniqueidentifier, no B ModifiedDate (datetime, not 1 Keys Constraints Triggers Indexes Statistics Production.ProductModellllustration Production.ProductModelProductDe A Production.ProductPhoto 88 Production.ProductProductPhoto Production Product Review Production ProductSubcategory B Production scrapReason Production Transaction History Production Transaction History Archiv Production.Product Modellllustration Production.ProductModelProductDe E Production.ProductPhoto Production.ProductProductPhoto E Production.ProductReview 3 Production. ProductSubcategory Columns me ProductSubcategoryD (PK, in 6- Product Category|D (FK, int, n Name (Name(nvarchar(50)), r Browguid (uniqueidentifier, no ModifiedDate (datetime, not i Keys Constraints Triggers Indexes Statistics + 2 Production.ScrapReason E Production Transaction History EEE Production. Transaction History Archiv Production UnitMeasure 5 Production.ProductListPrice History Production.Product Model Production.ProductModellllustration Production.Product ModelProductDe Production.ProductPhoto E Production.ProductProductPhoto Production.ProductReview Columns 0 ProductReviewID (PK, int, not - ProductID (FK, int, not null) ReviewerName (Name(nvarch ReviewDate (datetime, not nu Email Address (nvarchar(50), n Rating (int, not null) Comments (nvarchar(3850), n ModifiedDate (datetime, not : Keys Constraints Triggers Indexes Statistics E Production Productsubcategory Columns Production.Location Production. Product Columns ProductID (PK, int, not null) E Name (Name(nvarchar(50)), r ProductNumber (nvarchar(25) MakeFlag (Flag(bit), not null) FinishedGoodsFlag (Flag(bit), E Color (nvarchar(15), null) SafetyStockLevel (smallint, no ReorderPoint (smallint, not nu StandardCost (money, not nu ListPrice (money, not null) Size (nvarchar(5), null) - SizeUnitMeasureCode (FK, nel - WeightUnitMeasureCode (FK, & Weight (decimal(8,2), null) E DaysToManufacture (int, not i E ProductLine (nchar(2), null) E Class (nchar(2), null) E Style (nchar(2), null) C- ProductSubcategory|D (FK, in 6- ProductModellD (FK, int, null) E SellStartDate (datetime, not ni SellEndDate (datetime, null) DiscontinuedDate (datetime, 1 Browguid (uniqueidentifier, no ModifiedDate (datetime, not i Keys 100 10 1 NEM Di are to search ILIH + Production.ProductPhoto Production.ProductProductPhoto Production.ProductReview Production.ProductSubcategory IT Columns ro ProductSubcategory|D (PK, in - ProductCategoryD (FK, int, ni Name (Name(nvarchar(50)), r rowguid (uniqueidentifier, no ModifiedDate (datetime, not: Keys Constraints Triggers Indexes Statistics Production.ScrapReason 7 Production. Transaction History 2 Be Production. Transaction HistoryArchiv v e Production Product Production.ProductCategory Columns ProductCategoryID (PK, int, n E Name (Name(nvarchar(50)), r Browguid (uniqueidentifier, no ModifiedDate (datetime, notr Keys Constraints Triggers Indees Statistics Production.ProductCost History E Production Product Description Production ProductDocument Production.ProductInventory Production.ProductListPrice History E Production.Product Model Production Product Modellllustration Production Product ModelProductDe BE Production ProductPhoto EE Production ProductProductPhoto m Production ProductReview Production ProductSubcategory HO Production.ScrapReason O Production. Transaction History

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Download and examine the project task list Download project task listfrom the link provided in the module. Based on this task list, you will create a PERT chart and prepare a presentation file that...

12 - Diagram_0 WardropRyanAssig.. MBPHARWard (65))* Assignment06.sql - not connected* + x List Products, their subcategories, their categories, and their model. Show the model name, category name,...

--* BUSIT 103 assignment #6 DUE DATE : Consult course calendar --You are to develop SQL statements for each task listed. You should type your SQL statements under --each task. You are required to use...

* BusIT 103 Assignment #6 DUE DATE : To do from Microsoft SQL server management studio. You are to develop SQL statements for each task listed. You should type your SQL statements under each task....

MGMT-6082 Domestic and International Sourcing Mid Term Case Smart Phone Corporation (25%) Individual Submission (60%) Students are to submit their individual preparation on the Mid Term Case 72 hours...

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

Prepare the financial analysis to support your decision between bankruptcy,voluntary reorganization,and Chapter11reorganization.It must be complete and prepared in a professional level,with the...

Instructions: # This assignment has 3 questaions # Please upload the .ktr files below (transformation file) in case of Pentaho transformations Every information neede to solve this problem is there....

You will need to install SQL Server Express along with database services (there is one file that will install both), if you have not done so already, and you will need to attach the...

Suppose that scores on a particular test are normally distributed with a mean of 140 and a standard deviation of 15. What is the minimum score needed to be in the top 10% of the scores on the test?...

Should Toledo Shirt Company be loyal to a customer that has been excellent in the past or start the bankruptcy process to protect itself? What actions should Thurber take?

Summarize the challenges of electronic international business with cyber security

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...