2NF relations are those that are in 1NF with all the attribute types dependent on the ___ key.a.Compositeb.Primaryc.Foreignd.Alternate

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

A relation with 2 attributes is always in _______.a.1NFb.3NFc.2NFd.BCNF

An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.Question 5Answera.Superb.Primaryc.Subd.Candidate

A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.Options3NF2NFBCNF1NF

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