Question paper (build 07.05.20.19)
order should be set to 0.
For example, if you run the following queries on the table OrderDetails, the corresponding
orders will be updated.
-- test case 1 -> TotalAmount of the orders with OrderID = 3 and OrderID = 5 will be updated
INSERT OrderDetails (OrderID, ItemID, Quantity, Price)
VALUES (3, 2, 3, 75000.00), (5,27,2,40000.00)
-- test case 2 -> TotalAmount of the order with OrderID = 6 will be updated
8 of 8
Paper No: 10
delete from OrderDetails where OrderID = 6 and ItemID = 1
Question 10:
Write SQL statements to create a new reservation for a customer. The reservation should be
made for CustomerID = 7, with 5 guests, on November 20, 2025, at 19:15 PM. The
ReservationID should be 210.
After inserting the reservation into the Reservations table, assign the reservation to a table in
the Reservation Tables table. The assigned table should be the one with the smallest
TableID among all tables that have a capacity greater than or equal to 5.
