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 the 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

Topic Covered

Database First(1st) Normal form and repeating groups.

 

Fazal Rehman Shamil Click Here to Know More
Instructor, Researcher, Blogger, SEO Expert, Poet and Publisher of International Journal Of Software, Technology & Science ISSN : 2616 - 5325
Dear Professors and Resarchers!You are welome to Cite these tutorials in your research or slides etc. Please don't forget to mention the reference of website. Copy Paste of text is strcitly forbidden. Images can be reuse because images are protected with watermark.