First Normal Form is the entry point to database normalization. A table is in 1NF when every column holds a single, indivisible (atomic) value, when there are no repeating groups of columns such as Phone1, Phone2, Phone3, and when each row can be uniquely identified by a primary key. These rules sound simple, but applying them to a messy real-world spreadsheet-style table is where most of the learning happens.
In this course, 1NF matters because every later step depends on it. You cannot meaningfully look for partial dependencies (2NF) or transitive dependencies (3NF) until the data is in a flat, atomic, key-identified structure. The anomalies you studied earlier in this module - insertion, update, and deletion problems - are often made much worse by comma-separated lists and repeated column groups, so putting a table into 1NF is usually the first concrete repair you perform.
As you watch, keep three questions in mind. First, what exactly counts as atomic, and where do people disagree about it? Second, when a repeating group is removed, how many rows does the table gain, and what does that do to the key? Third, what becomes the primary key after the transformation - a single column, or a composite of two or more? Try to pause each video at the "before" table and sketch your own "after" table before the presenter reveals theirs.
A fast, widely watched overview that walks through the full normalization ladder - 1NF, 2NF, 3NF, BCNF, and the higher forms - using everyday examples rather than abstract notation. The opening portion focuses on 1NF, where the presenter illustrates multi-valued and composite attributes and shows how to flatten them into atomic columns and rows. The rest of the video previews where the module is headed after 1NF.
Gate Smashers is a well-known exam-prep channel whose explanations are concise and example-driven, and seeing 1NF in the context of the whole normalization sequence helps you understand why atomicity is only the first step.
A focused, single-topic treatment of First Normal Form that distinguishes the popular shorthand definition of 1NF from the more precise relational-theory definition. The presenter addresses common misconceptions about what atomicity really requires and why the rule is sometimes misunderstood or misapplied. Expect discussion of repeating groups and row identity as part of the definition.
Because it is devoted entirely to 1NF, this video gives the depth the topic deserves and directly supports the subtopics on atomicity and what 1NF actually is, including the nuances that textbook summaries gloss over.
A practical tutorial that introduces normalization generally and then applies 1NF to a sample table. It is structured as a step-by-step walkthrough, so you should see an unnormalized starting table, the problems it creates, and the restructured 1NF result. The format lends itself to following along with your own example.
Very Academy's hands-on, build-it-with-me style matches the "transforming an unnormalized table into 1NF step-by-step" and "before and after" subtopics, making it a good companion to the more definitional videos.
Together these three videos cover the full 1NF skill set targeted by MO2: recognizing and removing repeating groups, enforcing atomic column values, and designating a primary key for the resulting table. The focused 1NF videos build the conceptual precision needed to judge whether a table truly complies, which feeds directly into the validation work in MO5, while the before-and-after examples make visible the insertion, update, and deletion anomalies described in MO1. The broader normalization overview also previews the dependency analysis required for MO3 and MO4, so you can see how 1NF sets up the decompositions that follow later in this module.
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.