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  Name Marks
1 Shahzeb 98
2 Basit 90
3 Sameed 44
2 Basit 70

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  Name Marks
1 Shahzeb 98
2 Basit 90
3 Sameed 44

 

Fazal Rehman Shamil
Welcome to all friends. The reason for our success is only your love for T4Tutorials. Our team is always available to answer your queries regarding any kind of confusions or discussion regarding your study and career matters. For discussion with us please join our facebook group "T4Tutorials.com". The link of the group is mentioned below. Thanks and love to all for connecting with us. We are nothing without you. Love you all.....
https://web.facebook.com/groups/2066136233601097/

Leave a Reply