A database has been created for a Customer-Category relation. The relation contains the following attributes: consider the following list of attributes (a customer record length is variable because each customer can have a different number of contacts and each customer can be part of multiple categories.):

Customer ID (primary key)

Customer Name Customer Type

Contact Name (one to many)

Category Name (one to many)

City

State

ZIP Code

(i) When can a relation to be classified as 1NF. State whether the above relation is in 1NF and provide a reason for your answer.

(ii) When can a table to be classified as 2NF and state if the above table structure is already in 2NF. If the given table is not in 2NF, decompose it so that it is in 2NF.

(iii) When can a table to be classified as 3NF and state if table(s) you have after part (ii) are already in 3NF. If the table(s) are not already in 3NF, decompose them so that they are in 3NF