Consider a database with the following schema:

TextDescription automatically generated

The Catalog relation lists the prices charged for parts by Suppliers. For each of the following transactions, state the SQL isolation level that you would use and explain why you chose it$.$

$1.$ A transaction that adds a new part to a supplier's catalog. $(2$ marks$)$

$2.$ A transaction that increases the price that a supplier charges for a part. $(2$ marks$)$

$3.$ A transaction that determines the total number of items for a given supplier. $(2$ marks$)$