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

Welcome back itz — been a while! Let's pick up where you left off. Question 1 asks why the given table, which is in 1NF, is not in 2NF. 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. Drop the next question 📸