27
A Different View
Person(name, city)
Purchase(buyer, seller, product, store)
Product(name, maker, category)
We have a new virtual table:
Seattle-view(buyer, seller, product, store)
CREATE VIEW  Seattle-view  AS
         SELECT  buyer, seller, product, store
         FROM     Person, Purchase
         WHERE   Person.city = “Seattle”    AND
                          Person.name = Purchase.buyer