Sales (product_id, product_name, price, quantity, order_id).

The non-trivial functional dependencies for this table are:

1. Product_id product_name (b/c every product with the same name has the same product id)

2. Order_id quantity (b/c each order has its own quantity)

3. Product_id, quantity price (b/c the price varies depending on how much of the product someone is buying).

Give an example of an update anomaly for this table. Explain your example.

Any easy and helpful explanation please...