Database First(1st) Normal form and repeating groups
In this tutorial, we will learn about the followings;
- Database First(1st) Normal form
- Example of Database First(1st) Normal form
- Repeating groups
What is a first normal form?
A relation/table is in first normal form if it does not contains repeating groups.
What is a repeating group?
A repeating group is a group of two or more rows/record for an instance of an entity.
Example of first normal form
Here, Roll No 2 is the repeating group because Roll number 2 is for only one instance of entity student.
How to convert a table into first normal form?
We will remove the repeating groups;