Storage/Indexing/Views-Start the VM for assignment four. Inside the VM, click Start, type SSMS (to open SQL Server Management Studio), select Database Engine as the server type, and then click connect. Select Databases, then right click on the most current version of AdventureWorks database to create a new query for this assignment.
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. Make sure to provide a screenshot for each.
1. You notice when running queries that the database is returning results very slowly. Make sure to address the following:
Discuss likely causes for the slow returns.
Propose solutions for speeding up the process.
Explain why implementing the index will speed queries.
2. Discuss two indexing issues that can negatively affect databases. Provide specific examples in your discussion.
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 Product ID, 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.
Submit the Word document (with screenshots).
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
Answer Preview-Storage/Indexing/Views-SYM-400
