Reference no: EM133023290
Take a moment to review the details of this assignment below and gather any necessary files. Once you're ready to submit your assignment, move on to Step 2.
Assessment Description
The purpose of this assignment is to create temporary tables and document them using an Entity Relationship Diagram (ERD).
For this assignment, continue to play the role of the data analyst for Adventure Works Cycling Company.
Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy.
create Microsoft Word document that includes the SQL query code for the temporary table that includes the dates of each sales order.
-Create temporary table for each of the Topic 4 assignment data components, as described in the table below.Temporary Table Name
Topic 4 Assignment Query
#MyProduct
Find the product ID for the LL Road Frame - Black 60
#MyPriceHistory
Find the listing price of the LL Road Frame - Black 60. Display ProductID, EndDate, and ListPrice.
#MySalesOrderDetail
How many orders have been placed for LL Road Frame - Black 60?
-Use the skills you have learned and practice writing a query to determine the dates of each sales orders from a table you have not looked at yet. Create temporary table called #AllSalesOrderDates for this information.
-Use Draw.io to create new entity relationship diagram (ERD) to document the addition of the temporary tables and the work stream. Show the relationship between the tables.Compile the Draw.io, Excel data file, and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor.