Last updated on:August 25th, 2018,

Database First(1st) Normal form and repeating groups

Database First(1st) Normal form and repeating groups

In this tutorial, we will learn about the followings;

  1. Database First(1st) Normal form
  2. Example of Database First(1st) Normal form
  3. 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

Roll No NameMarks
1Shahzeb98
2Basit90
3Sameed44
2Basit70

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;

Roll No NameMarks
1Shahzeb98
2Basit90
3Sameed44
0Shares

Leave a Reply

Your email address will not be published.