Use SQL to make the following changes to the TAL Distributors 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 or save it to a document. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task.Create a view named MAJOR_CUSTOMER. It consists of the customer number, name, balance, credit limit, and rep number for every customer whose credit limit is $10,000 or less.a. Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER view.b. 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.c. Write and execute the query that the DBMS actually executes.d. Does updating the database through this view create any problems? If so, what are they? If not, why not?