First Normal form in DBMS

Let’s study about Database First(1st) Normal form and repeating groups.
What is the first normal form?
A relation/table is in the 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/records for an instance of an entity.

Video Lecture with full of animations

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 an entity student.

How to convert a table into the first normal form?

We will remove the repeating groups;

Roll No NameMarks
1Shahzeb98
2Basit90
3Sameed44

Excercise 1NF to 5NF

Example: 1NF

Original Table
Emp_IDNameLanguage
1.    T4Tutorials AEnglish
2.    T4Tutorials BEnglish, Chinese
3.    T4Tutorials CChinese
4.    T4Tutorials DEnglish, German, Russian

FIRST NORMAL FORM

FIRST NORMAL FORM
Emp IDNameLanguage
1.T4Tutorials AEnglish
2.T4Tutorials BEnglish
2.T4Tutorials BChinese
3.T4Tutorials CChinese
4.T4Tutorials DEnglish
4.T4Tutorials DGerman
4.T4Tutorials DRussian

Topic Covered

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

normal forms in DBMS with examples.
normalization in the database with example tables.
normalization example.
first normal form SQL.
normalization in the DBMS ppt.

Subscribe for Friendship

Prof. Fazal Rehman Shamil
Latest posts by Prof. Fazal Rehman Shamil (see all)

    Buy advertisement space on T4Tutorials

    For more details email [email protected]