Non-Updatable Views

CREATE VIEW Seattle-view AS

SELECT seller, product, store

FROM Person, Purchase

WHERE Person.city = ‘Seattle’ AND

Person.name = Purchase.buyer

How can we add the following tuple to the view?

(‘Joe’, ‘Shoe Model 12345’, ‘Nine West’)

Previous slide

Back to first slide

View graphic version