Which normal form ensures that there is no non-prime attribute that is transitively dependent on the primary key?a.First Normal Form (1NF)b.Second Normal Form (2NF)c.Third Normal Form (3NF)d.Boyce-Codd Normal Form (BCNF)

Which of the following normal forms is achieved when all non-key attributes are fully functionally dependent on the primary key?Question 11Answera.Second Normal Form (2NF)b.Boyce-Codd Normal Form (BCNF)c.First Normal Form (1NF)d.Third Normal Form (3NF)

Which normalization form eliminates transitive dependencies?Review LaterFirst Normal Form (1NF)Second Normal Form (2NF)Third Normal Form (3NF)Boyce-Codd Normal Form (BCNF)

Which normal form ensures that there are no repeating groups of data and all non-key attributes are fully functionally dependent on the primary key?OptionsFirst Normal Form (1NF)Third Normal Form (3NF)Boyce-Codd Normal Form (BCNF)Second Normal Form (2NF)

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

A given table which does not have a transitive dependency and is in the second normal form is known to be in the A. Third normal form B. General form C. Second normal form D. First normal form