1. Create a temporary table for each of the  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?

 

1. writing a query to determine the dates of each sales orders from a table you have not looked at yet.
2. Create a temporary table called #AllSalesOrderDates for this information.
3. Create a new entity relationship diagram (ERD) to document the addition of the temporary tables and the work stream. Show the relationship between the tables.

Answer rating: 100% (QA)

It seems like you are working on a database query assignment related to temporary tables specificall... View the full answer