Question

2nd Normal Form specifically applies to which type of tables?

1) Reference Tables
2) Composite Key Tables
3) Resource Tables
4) All of the above
5) None of the above

Answer 1

The 2nd Normal Form specifically applies to Composite Key Tables. It ensures that every non-key attribute depends on the whole key, not just part of it.

Step-by-step explanation:

The 2nd Normal Form specifically applies to Composite Key Tables.

In a database, a composite key is a key that consists of two or more attributes/columns. It is used to uniquely identify a record within a table. The 2nd Normal Form ensures that every non-key attribute depends on the whole key, not just part of it.