Use SQL to make the following changes to the Premiere Products database (see Figure 1-2 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly, If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output. For any exercises use that command not supported by your version of SQL, write the command accomplish the task. Create a viewed named MAJOR_CUSTOMER. It consist of the customer number, name, balance, credit limit, and rep number for every customer whose credit limit is $10,000 or less. Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER view. Write and execute the command to retrieve the customer number and name of each customer in the MAJOR_CUSTOMER view with a balance that exceeds the credit limit. Write and execute the query that the DBMS actually executes. Does updating the database through this view create any problems? If so, what are they? If not, why not? Use SQL to make the following changes to the Premiere Products database (see Figure 1-2 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly, If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output. For any exercises use that command not supported by your version of SQL, write the command accomplish the task. Create a viewed named MAJOR_CUSTOMER. It consist of the customer number, name, balance, credit limit, and rep number for every customer whose credit limit is $10,000 or less. Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER view. Write and execute the command to retrieve the customer number and name of each customer in the MAJOR_CUSTOMER view with a balance that exceeds the credit limit. Write and execute the query that the DBMS actually executes. Does updating the database through this view create any problems? If so, what are they? If not, why not