Create a view named PART ORDER. It consists of the part number, description, price, order number, order date, number ordered, and quoted price for all order lines currently on file.
a. Write and execute the CREATE VIEW command to create the PART ORDER view.
b. Write and execute the command to retrieve the part number, description, order number, and quoted price for all orders in the PART ORDER view for parts with quoted prices that exceed $100.
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?

Answer rating: 100% (QA)

a For the creation of part view CREATE VIEW PartOrder AS SELECT PartNum Part Description PartP... View the full answer