Look at the given table called ‘Item’ and answer the questions.Ite

1.	Look at the given table called ‘Item’ and answer the questions.ItemIdItemNameItemStockItemDOPQuanity Purchased1. Suggest the data types of all the fields.2. Which two fields can act as the primary key from the above table?
Answer» 1. ItemID —> Text ItemName —> Text ItemStock —> Number ItemDOP —> Date QuantityPurchased —> Number 2. ItemID and ItemName can act as primary key.

Look at the given table called ‘Item’ and answer the questions.ItemIdItemNameItemStockItemDOPQuanity Purchased1. Suggest the data types of all the fields.2. Which two fields can act as the primary key from the above table?

Answer»

1. ItemID —> Text

ItemName —> Text

ItemStock —> Number

ItemDOP —> Date

QuantityPurchased —> Number

2. ItemID and ItemName can act as primary key.