all questions. the data required can be improvised. I need to know how to get to the answer, the structure of the code. will rate ?? if all are answered. thank you

stributors SQL to make the following changes to the TAL Distributore database (see Figure 1-2 in Chapter 1). After each change, execute an appropriate query to show that the change was ade correctly. If directed to do so by your instructor, use the information provided with the ter 3 Exercises to print your output or save it to a document. For any exercises that use commands not supported by your version of SOL, write the command to accomplish the task 1. Create a view named MAJOR CUSTOMER. It consists of the customer number, name, bal- ance, 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 limit Does updating the database through this view create any probiems? If so, what are b. customer in the MAJOR CUSTOMER view with a balance that exceeds the credt C. Write and execute the query that the DBMS actually executes d. they" not, why not? 2 Create a view named ITEM ORDER It consists of the item number, description, price order number, order date, number ordered, and quoted price for all order lines currently