32
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”)
We need to add “Joe” to Person first, but we don’t have all its attributes