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?