Problem 3: View Specification in SQL [25 pts] Consider a database schema consisting of three relations, whose schemas are given below (the key fields are underlined). Please load data into your tables and test your answers on Oracle. Product( model, manufacturer, type) PC/model, speed, ram, hd, rd, price) Laptop/ model, speed, ram, hd, screen, price) Consider the following view PCPriceList defined as: CREATE VIEW PCPriceList AS Select model, price from PC a) Use the above view to find the PC with the cheapest price. Show the SQL query. Can you delete from this view directly? Discuss. Show how! b) Can you perform an insert such as: INSERT INTO PCPriceList(model) VALUES (2005)? When yes and when no? Discuss. c) What about an insert such as: INSERT INTO PCPriceList (price) VALUES (1700)? Discuss. Show wwwwww what happens. d) Now using SQL DDL, define a second view extended manufacturer, model, speed, ram, hd, rd, price, type). This view will give every PC made by each manufacturer. Can you delete from this extended PC view? Discuss. Show what happens