Database Normalization: First Normal Form (1NF) Basics
Table in 1NF has atomic values & no repeating groups. Each cell holds a single value, not lists. Ensures data consistency & easier management.
First Normal Form (1NF) It is the most basic level of database normalization. A table is in 1NF if it meets the following criteria: Atomic Values: All the columns should contain atomic (indivisible) values, meaning each cell in the table should hold a single value. No multiple values (like a list) in a single cell. No Repeating Groups: There should be no repeating groups or arrays in the table. Each piece of data should be stored in a separate row and column. Example of a Table Not in 1NF OrderID CustomerName PizzaSize Toppings 001 Alice Medium Pepperoni, Mushrooms 002...