Solving a relational query: part 2

Standard
Tuple Image from [www.youvan.com], 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

  1. Pingback: Solving a relational query: part 3 | cartesian product

  2. Pingback: Solving a relational query: part 4 | cartesian product

  3. Pingback: Solving a relational query: part 5 | cartesian product

Comments are closed.