Question: Problem 20 (4 pts): If we are given the following table. ORDER_ITEMS OrderId Region Quantity Hann east east center center west Suppose that we want


Problem 20 (4 pts): If we are given the following table. ORDER_ITEMS OrderId Region Quantity Hann east east center center west Suppose that we want to insert a new record into the ORDER ITEMS with an OrderID=5, Region=west, and Quantity=4. Write the relational algebra to achieve this. Hint: using assignment operator f and union operator "U. Ans: Problem 19 (4 pts): If we are given the following table. ORDER ITEMS OrderId. Region Quantity east east center center west Suppose that we want to delete all order_items with an order quantity greater than 3, give the relational algebra to achieve this. Hint: using assignment operatorf and subtracting operator. Ans
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
