Explain why the given table, which is in 1NF, is not in 2NF, using the provided composite primary key and identifying partial dependencies.

For a table to be in 2NF (Second Normal Form), it must first be in 1NF, and all non-key attributes must be fully functionally dependent on the entire primary key. This means if the primary key is composite (made of multiple columns), no non-key attribute should depend only on a part of the primary key.

In this table, a suitable composite primary key would be (StudNo, SubCode) because this combination uniquely identifies each practical lesson a student takes.

Here are two reasons why the table is not in 2NF:

• Reason 1: Attributes like Surname, Other Name, and Sex are functionally dependent only on StudNo, which is only a part of the composite primary key (StudNo, SubCode). This is a partial dependency.
• Reason 2: The attribute SubName (e.g., Physics, Biology) is functionally dependent only on SubCode (e.g., 780, 710), which is also only a part of the composite primary key (StudNo, SubCode). This is another partial dependency.