Solving a relational query: part 2

Tuple Image from [], Example 7 i...
Image via Wikipedia

With thanks to Professor Paul A. Rubin, I think this may be the way to solve this:

Relational algebra formula
This joins LOT to a relation with one attribute (LOT_ID) made up from tuples where LOT_ID should only be returned where no bids have been made that are equal or greater than the reserve price.

Very difficult part question for an exam, though 😦

3 thoughts on “Solving a relational query: part 2

Comments are closed.