Second Normal Form (2NF) is the next step after 1NF in the normalization process. Once a table is in 1NF — every attribute holds a single atomic value and a primary key has been designated — the question becomes whether every non-key attribute actually depends on the whole primary key. When a table has a composite primary key (a key made of two or more attributes), it is possible for some non-key attribute to be determined by only part of that key. That situation is called a partial dependency, and 2NF exists to remove it: a table is in 2NF if it is in 1NF and every non-key attribute is fully functionally dependent on the entire primary key.
This matters because partial dependencies cause the same anomalies you studied earlier in the module. If a product's name is stored in an order-line table keyed on (OrderID, ProductID), the product name repeats on every line, must be updated in many rows at once, and cannot be recorded at all until some order references it. Decomposing the table — pulling the partially dependent attributes out into their own table keyed on the determinant — removes the redundancy without losing information, because the original table can be reconstructed by joining.
As you watch the videos below, keep three things in view. First, notice how each presenter writes out the functional dependencies before judging the table; the dependencies, not intuition, decide the answer. Second, watch for the shortcut rule that a table with a single-attribute primary key and no repeating groups is automatically in 2NF, and make sure you understand why. Third, follow the decomposition carefully: which attributes move, what becomes the key of the new table, and what stays behind as a foreign key.
A single walkthrough that takes one example table from unnormalized form all the way to 5NF, with a timestamped section on Second Normal Form beginning around 6:30. Because it uses the same table throughout, you can see exactly which columns are removed at the 2NF step and why the 1NF result was not yet good enough. The 3NF segment that follows at 10:20 shows what is left over after partial dependencies are handled.
Database Star is a well-known SQL and database-design channel, and the continuous single-example format is ideal for this topic because 2NF only makes sense relative to the 1NF table that preceded it.
A compact lecture-style treatment of all the normal forms — 1NF, 2NF, 3NF, BCNF, 4NF and 5NF — presented with real-life examples in roughly eleven minutes. The 2NF portion focuses on the definition involving full functional dependency on the primary key and the role of composite keys in creating partial dependencies. It is paced like an exam-review session, with the rules stated explicitly.
Gate Smashers is a widely viewed DBMS teaching channel, and this video gives you a crisp, memorizable statement of the 2NF rule and the prime/non-prime attribute vocabulary you will need when detecting partial dependencies.
Decomplexify builds the discussion around one deceptively simple table and uses it to test whether viewers really understand what each normal form requires. Expect careful attention to where the common shortcut definitions of 1NF, 2NF and 3NF break down, and to reasoning directly from the functional dependencies rather than from memorized phrases.
This is the right video to watch after the overviews: it pushes you past rote recitation of the 2NF rule toward the kind of careful dependency analysis you will need to justify a decomposition.
Together these videos target MO3 directly: all three show how to spot a non-key attribute that depends on only part of a composite key, and how to split the table so that every remaining attribute is fully dependent on the whole key. Because each video treats normalization as a continuous sequence rather than isolated rules, they also reinforce MO2 by showing the 1NF starting point that 2NF builds on, and they preview MO4 by continuing into transitive dependencies and 3NF. The anomaly discussions that motivate each step support MO1, and the Decomplexify video in particular models the careful, dependency-by-dependency checking you will use for MO5 when confirming that every table in a finished schema satisfies 1NF, 2NF and 3NF.
These videos were chosen from YouTube on October 2, 2026. Each has captions; the player turns them on. Videos on YouTube can be changed or removed — if one no longer plays, tell your instructor. If a player does not appear, use its Watch on YouTube link.