Question
In this assignment, students will use the most current version of AdventureWorks database and practice indexing appropriately. The ability to evaluate and implement various storage
In this assignment, students will use the most current version of AdventureWorks database and practice indexing appropriately.
The ability to evaluate and implement various storage structures, index selections, and views is an important aspect of database management.
Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a CSV file for a visual check of accuracy.
Create a Microsoft Word document that includes the SQL query code used to explore the database tables and complete the following criteria.
3. The sales manager has received a customer request that all products be searchable according to color specifications. In this particular case, the customer is seeking red products. Build a view consisting of ProductID, Product, and Color, and query the new view.
4. The sales manager presented the customer with the view you created in question three. The customer is still unhappy with the product list because many of the items were not available for bulk purchase or were not yet in storage, which resulted in delays. To address the problem, rebuild the view with multiple joins and filter your query to only look up items from the "Finished Goods Storage" located within the Name column from the Location table utilizing LocationID (primary key). Bring in the "Quantity" field from the Inventory table. Rerun the query in the view.
using adventure works sql
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started