With thanks to Professor Paul A. Rubin, I think this may be the way to solve this:
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 😦
Related articles
- Solving a relational query: part 1 (cartesianproduct.wordpress.com)
3 responses to “Solving a relational query: part 2”
[…] cartesian product Stuff about computing Skip to content HomeAbout ← Solving a relational query: part 2 […]
[…] Solving a relational query: part 2 (cartesianproduct.wordpress.com) […]
[…] Solving a relational query: part 2 (cartesianproduct.wordpress.com) […]