Part I
Draw Entity Relationship diagram for Adventure Works database.
Part II
Write SELECT statements for the following questions:
For each of these statements, include a screenshot of the SQL statements and results. Make sure to include the statement execution, including the resulting data.
• Display all columns and all rows from the Customer table under Sales.
• Display the ProductID, ProductNumber and ListPrice for all rows in the Product table.
• Modify query 2 so that the column headings are as follows:
• \”ID,\” \”Number,\” and \”List Price\”
• Display the full customer name for all customers in the Customer table.
• Display information about the Sales store with meaningful headers
• Display Work orders with stocked quantity less than 5. Then another query to display work orders with stock quantity between 10 and 15
• Display all the shipping method that has rate of more than $1.0 per Oz
Combine all of the screenshots into a single Word document, and submit this for grading.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|