Question: This is about solutions and strategies for improving the performance of SQL queries.
Using the online Library or the Internet, research the subsequent:
• SQL performance tuning
• Programming with SQL
Based on your research and understanding, complete the subsequent tasks:
Question 1: Evaluate the given statement and discuss some approaches to address the issue: "We spent several million dollars a few years ago to create a database for managing our business. In the past several months, we acquired a new business but its data does not fit in our current system. What can we do to solve this problem?"
Question 2: Discuss some possible solutions and strategies for improving the performance of SQL queries and their ability to provide data to users:
Question 3: Identify the performance or usability issues that need to be addressed.
Question 4: Outline a possible solution for each issue. Use supporting examples, if necessary.
Question 5: Briefly describe how you would implement your solutions.
Question 6: Discuss how cardinality affects database design? Provide an example to support your answer.
Question 7: Discuss the importance of triggers and some risks associated with their use.
Question 8: In your opinion, state when using triggers makes the most sense. Why? When should you not use them? Why?
Describe each and every question in depth with examples.