Please answer b and c similar to answer in a
Using the following base Tables:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Suppose we create the following View:
CREATE VIEW NewPC AS
SELECT maker, model, speed, ram, hd,price
FROM Product, PC
WHERE Product,model = PC.model ANDtype = ‘PC’;
Notice that we have made a check for consistency: that the modelnumber not only appears in the PC relation, but the type attributeof Product indicates that the product is a PC.
b) Write an instead-of trigger to handle an insertion into theview?
CREATE TRIGGER NewPCInsert
INSTEAD OF INSERT ON NewPC
REFERENCING NEW ROW AS NewRow
FOR EACH ROW
(INSERT
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured