Question: 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

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 ProductID, Product, and Color, and query the new view. 4. The sales manager presented the customer with the view you created in question 3. 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 add the parameter for "Finished Goods Storage" in the Location table. Bring in the "Quantity" field from the Inventory table. Rerun the query in the view. Question 1 I understand and can figure out question 2, but 3 and 4 is where I am stumped on.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!