Question

When each nonprimary key attribute is identified by the whole key, the relation is said to be in at least:

second normal form.
third normal form.
fourth normal form.
fifth normal form.
a relational form.

Answer 1

Second Normal Form

Step-by-step explanation:

Normalization is key to efficient database design. It assures that database systems are not inaccurate, slow, and inefficient and they might not produce the information you expect, The two main objectives of the normalization are; eliminate redundant data (storing the same data in more than one table) and ensure data dependencies make sense,

In the second normal form data, which does not directly dependent on table’s primary key is moved into another table.