Exercise

Consider the following table.

Give an example of update anomaly, an example of deletion anomaly and an example of insertion anomaly knowing that

A product has many suppliers and can have many other products as a substitute $($i$.$e$.$ a product can be replaced by its substitute$).$

The purchase price is determined by a supplier for a product, while the sale price is for a given product regardless of the supplier.

The quantity is for a given product, again regardless of the supplier.

$\backslash$table$[[$ProductID$,$SupplierID,Substitute,Quantity,PurchasePrice,SalePrice$],[123,987,121,509,200,250],[123,987,122,509,200,250],[123,998,121,509,210,250],[123,998,122,509,210,250],[342,987,344,120,99,189],[432,789,433,100,110,200]]$