Question

why is it mandatory to have a unique field to each record in tables​

Answer 1

Answer:

Just because to identify the uniqueness of a row .

and that is done by primary key.

Explanation:

hope it helps you