Give me 5 examples of Conditional Union, Intersection and Difference
For example, if we have two Relations (tables):
DP_DesiredProducts(product, quantity)
SP_StoreProducts(product, quantity)
We can find the list of products that we can buy in the store with the Conditional Intersection (ON SP.product = DP.product AND SP.quantity >= DP.quantity), and also the products that I won’t be able to buy with the Conditional Difference.
That is one example, I need 5 more. Obviously, all examples need to be different, this one is about buying, the others should be about any other subject, but they need to be applicable in real life, like that one.
Sample Solution
