More Examples

CREATE VIEW Seattle-view AS

SELECT buyer, seller, product, store

FROM Person, Purchase

WHERE Person.city = “Seattle” AND

Person.per-name = Purchase.buyer

SeattleView(buyer,seller,product,store) :-

Person(buyer, “Seattle”, phone),

Purchase(buyer, seller, product, store).

Previous slide

Next slide

Back to first slide

View graphic version