Question: Q5 [1 pt]: Using the following base Tables: Product(maker, model, type) PC (model, speed, ram, hd, price) Suppose we create the following View: CREATVIEW NewPC

 Q5 [1 pt]: Using the following base Tables: Product(maker, model, type)

Q5 [1 pt]: Using the following base Tables: Product(maker, model, type) PC (model, speed, ram, hd, price) Suppose we create the following View: CREATVIEW NewPC AS SELECT maker, model, speed, ram, hd, price FROM Product, PC WHERE Product.model_PC.model AND type='PC.; Notice that we have made a check for consistency: that the model number not only appears in the PC relation, but the type attribute of Product indicates that the product is a PC. a) Is this View updatable? b) Write an instead-of trigger to handle an insertion into the view? c Write an instead-of trigger to handle an update of the price? d) Write an instead-of trigger to handle a deletion of a specified tuple from this view

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!