When is a relation considered to be in first normal form (1NF)?Select one:a.When there are no dependencies of an attribute on another attribute in the tableb.When there are no compound primary keys or partial key that can have a null valuec.When there are no partial dependencies or transitive dependencies on a primary keyd.When there are no repeating groups of values of an attribute in one or more columns

Which of the following is true for a relation in First Normal Form (1NF)?Question 13Answera.It contains no repeating groups or arraysb.It has a primary keyc.All attributes depend on the whole primary keyd.It contains no transitive dependencies

Which of the following describes a relation is in first normal form (1NF)?Select one:a.It has no identical rowsb.It has no repeating groupsc.It has no partial functional dependenciesd.It has no transitive functional dependencies

When is a relation considered to be in second normal form (2NF)? (Select the best answer.)Select one:a.When there are no repeating groups in a relationb.When there are no transitive functional dependenciesc.When there are no dependencies on part of the primary keyd.When there are no dependent attributes in transitive relation

WHAT IS TRUE ABOUT 2NF?Select one:a. BOTH OF THE ABOVEb. RELATION SHOULD BE IN 1NF.c. ALL ATTRIBUTES OTHER THAN PRIMARY KEY ARE FULLY FUNCTIONALLY DEPENDS ON PRIMARY KEYd. NONE OF THE ABOVE

Which statement best describes the purpose of Second Normal Form (2NF)?a.2NF allows redundancy to be eliminated completely from the relationb.2NF allows for the nesting of relations within relations, enhancing data organizationc.2NF ensures that every non-prime attribute is fully functionally dependent on the entire candidate key, thus removing partial functional dependenciesd.2NF ensures that every attribute in the relation is functionally dependent on the primary key