User Profile

Collapse

Profile Sidebar

Collapse
scorpiomailin
scorpiomailin
Last Activity: Oct 12 '06, 02:07 PM
Joined: Oct 12 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • scorpiomailin
    started a topic Help with Relational Algebra

    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...
    See more | Go to post

  • scorpiomailin
    started a topic Help with Relational Algebra

    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...
    See more | Go to post
No activity results to display
Show More
Working...