Help with Relational Algebra

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • scorpiomailin
    New Member
    • Oct 2006
    • 2

    #1

    Help with Relational Algebra

    Hello Guys...
    thanks in advance jst wondering if any1 knows answer to this....
    if this is the SQL query

    Author(name, hometown, publisher)
    Textbook(tname, aname, price)
    select A.name, publisher from Author A, Textbook T
    where T.aname = A.name and not exists (select * from Textbook S
    where S. price > T.price);


    What would be an efficient relational algebra????? so that there are minimal tuples to be processed...
Working...