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.