Disambiguating Attributes

SELECT Person.name

FROM Person, Purchase, Product

WHERE Person.name=buyer

AND product=Product.name

AND Product.category=‘telephony’

Product ( name, price, category, maker)

Purchase (buyer, seller, store, product)

Person( name, phone number, city)

Find names of people buying telephony products:

Previous slide

Next slide

Back to first slide

View graphic version