Q$2$: Create a view named ITEM$\_$ORDER. It consists of the item number, description, price, order number, order date, number ordered, and coated price for all order lines currently on file.

a$)$ Write and execute the CREATE VIEW command to create the ITEM$\_$ORDER view.

b$)$ Write and execute the command to retrieve the item number, description, order number, and coated price for all orders in the ITEM$\_$ORDER view for items with coated prices that exceed $$100.$

c$)$ Write and execute the query that DBMS actually executes.

d$)$ Does updating the database through this view create any problems? If so$,$ what are they? If not, why not?