Select the correct answerWhich normal form ensures that there are no repeating groups of data and all non-key attributes are fully functionally dependent on the primary key?OptionsSecond Normal Form (2NF)First Normal Form (1NF)Third Normal Form (3NF)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 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 normal form eliminates the possibility of data anomalies due to insert, update, or delete operations? Group of answer choicesThird Normal Form (3NF)First Normal Form (1NF)Second Normal Form (2NF)All the Available Options

If a table is in Third Normal Form (3NF), which of the following must be true?Group of answer choicesAll attributes are functionally dependent on the primary keyIt is in 1NF and 2NFIt has no transitive dependenciesAll the Available Optio

Choose the correct answerWhich forms simplifies and ensures that there are minimal data aggregates and repetitive groups:Options1NF3NFNone of theseAll of these2NF