A table includes the following attributes: StudNo, Surname, Other Name, Sex, SubCode, SubName, Lab.No. Identify the primary key and determine if the table is in 2NF. Explain your reasoning.

The table records practical lessons for students in different labs. A student can take multiple subjects, and a subject can be taken in different labs. To uniquely identify each practical lesson, the combination of StudNo, SubCode, and Lab.No is required. Thus, the composite primary key is (StudNo, SubCode, Lab.No).

A table is in 2NF if it is in 1NF and all non-key attributes are fully functionally dependent on the entire primary key. A partial dependency occurs when a non-key attribute depends on only a part of the composite primary key.

• Reason 1: The attributes Surname, Other Name, and Sex are dependent only on StudNo. For example, StudNo 'DM1' always corresponds to 'KOME', 'ROLAND', and 'M', regardless of the SubCode or Lab.No. Since StudNo is only a part of the composite primary key (StudNo, SubCode, Lab.No), this constitutes a partial dependency.

• Reason 2: The attribute SubName is dependent only on SubCode. For example, SubCode '780' always corresponds to 'Physics', regardless of the StudNo or Lab.No. Since SubCode is only a part of the composite primary key (StudNo, SubCode, Lab.No), this also constitutes a partial dependency.

Therefore, the table is not in 2NF because it contains partial dependencies.

Reason 1: Non-key attributes like Surname, Other Name, and Sex are functionally dependent on only a part of the composite primary key (StudNo).
Reason 2: The non-key attribute SubName is functionally dependent on only a part of the composite primary key (SubCode).