Using DBeaver, Choosing SQL sever 

Tpying the information to log in the database.

Connection values: 

Server Type = Database Engine Server 

Name = boyce.coe.neu.edu 

Authentication = SQL Server 

Authentication Login = INFO6210 

Password = NEUHusky!

Transcribed Image Text:

/* Bill of Materials - Recursive */ /* The following code retrieves the components required for manufacturing the "Mountain-500 Black, 48" (Product 992). Modify the code to retrieve the most expensive component(s) that cannot be manufactured internally. Use the list price of a component to determine the most expensive component. If there is a tie, your solutions must retrieve it. */ -Starter code WITH Parts(AssemblyID, Component ID, PerAssemblyQty, EndDate, Component Level) AS SELECT b. ProductAssemblyID, b. ComponentID, b. PerAssemblyQty, b. EndDate, AS Component Level FROM Production. Bill0fMaterials AS b WHERE b. ProductAssemblyID= 992 AND b. EndDate IS NULL UNION ALL SELECT bom. ProductAssembly ID, bom. Component ID, bom. PerAssemblyQty, bom. EndDate, Component Level + 1 FROM Production.BillofMaterials AS bom INNER JOIN Parts AS p ON bom. ProductAssemblyID = p. ComponentID AND bom. EndDate IS NULL SELECT AssemblyID, ComponentID, Name, PerAssemblyQty, Component Level FROM Parts AS p INNER JOIN Production. Product AS pr ON p.Component ID pr. Product ID ORDER BY Component Level, AssemblyID, ComponentID; /* Bill of Materials - Recursive */ /* The following code retrieves the components required for manufacturing the "Mountain-500 Black, 48" (Product 992). Modify the code to retrieve the most expensive component(s) that cannot be manufactured internally. Use the list price of a component to determine the most expensive component. If there is a tie, your solutions must retrieve it. */ -Starter code WITH Parts(AssemblyID, Component ID, PerAssemblyQty, EndDate, Component Level) AS SELECT b. ProductAssemblyID, b. ComponentID, b. PerAssemblyQty, b. EndDate, AS Component Level FROM Production. Bill0fMaterials AS b WHERE b. ProductAssemblyID= 992 AND b. EndDate IS NULL UNION ALL SELECT bom. ProductAssembly ID, bom. Component ID, bom. PerAssemblyQty, bom. EndDate, Component Level + 1 FROM Production.BillofMaterials AS bom INNER JOIN Parts AS p ON bom. ProductAssemblyID = p. ComponentID AND bom. EndDate IS NULL SELECT AssemblyID, ComponentID, Name, PerAssemblyQty, Component Level FROM Parts AS p INNER JOIN Production. Product AS pr ON p.Component ID pr. Product ID ORDER BY Component Level, AssemblyID, ComponentID;