First Normal Form (1NF)
A database is said to be in first normal form if does not contain any repeating columns or repeating groups of columns.
A table is said to be in first normal form, if it satisfies following conditions:
- All data values in a column are atomic.
- There are not repeating groups.
- Each column or field has unique name.
Let’s take an example of Student table. The table contains information about student hobbies.
You can see there are many values in Hobby column separated by commas. Thus value in Hobby column is not atomic. As per first normal form (1NF), the value in Hobby column should be atomic in nature.