Hello, everyone. Today we will know about the First Normal Form of normalization in DBMS. Previously we discussed the basic concept of normalization, we saw and understood how data redundancy can lead to several issues and how normalization can minimize data redundancy.
We will learn about the first normal form, which is like the step one process of the normalization in DBMS.
What is the First Normal Form of Normalization in DBMS?
The First Normal Form expects you to design your table in such a way that it can easily be extended, and it is easier for you to retrieve data from it whenever required. So we can say the first normal form is the basic requirement and this should become your default nature while creating tables to store data. Also, it is the step one to move on to second and third normal form.
There are several rules for First Normal Form in DBMS,
First Normal Form, Rule 1:
- Each column of your table must be single valued, which means it should not contain multiple values.
First Normal Form, Rule 2:
- In each column, the value stored must be of the same kind. For example, if you name a column date of birth, to save the date of births of a set of people, then you cannot or you must not save names of some of them in that column along with date of births of others in that particular column. It should hold only Date of Birth for all the entries of rows.
First Normal Form, Rule 3:
- Expects each column to have a unique name. If one or more columns have the same name, the DBMS system will be left confused.
First Normal Form, Rule 4:
- It doesn’t matter in which order you store the date in your table.
Though all the rules are self explanatory. Still, let’s take an example where we will create a table to store student data which will have the student’s roll number, their name and the name of subjects they have opted for. So we will be creating a table with three columns, we can obviously have as many columns in a table as we want. But for our example, we only need three, we will name the columns, roll number, name, subject, let’s add some data to our table.
Now with data added, our table already satisfies three rules out of the four rules. As all our column names are unique. We have stored data in the order we wanted to and we have not mixed different types of data in our columns.
If anyone wants us to share their content on our website, please contact us or email us to email@example.com.
TECHSIKHSHA IS A TECHNICAL GUIDE WEBSITE WHERE YOU CAN FIND VARIOUS TYPES OF TECHNICAL TIPS. STAY WITH US AND HELP US TO GROW.