- Blog Categories
- Project Management
- Agile Management
- IT Service Management
- Cloud Computing
- Business Management
- BI And Visualisation
- Quality Management
- Cyber Security
- Most Popular Blogs
- PMP Exam Schedule for 2025: Check PMP Exam Date
- Top 60+ PMP Exam Questions and Answers for 2025
- PMP Cheat Sheet and PMP Formulas To Use in 2025
- What is PMP Process? A Complete List of 49 Processes of PMP
- Top 15+ Project Management Case Studies with Examples 2025
- Top Picks by Authors
- Top 170 Project Management Research Topics
- What is Effective Communication: Definition
- How to Create a Project Plan in Excel in 2025?
- PMP Certification Exam Eligibility in 2025 [A Complete Checklist]
- PMP Certification Fees - All Aspects of PMP Certification Fee
- Most Popular Blogs
- CSM vs PSM: Which Certification to Choose in 2025?
- How Much Does Scrum Master Certification Cost in 2025?
- CSPO vs PSPO Certification: What to Choose in 2025?
- 8 Best Scrum Master Certifications to Pursue in 2025
- Safe Agilist Exam: A Complete Study Guide 2025
- Top Picks by Authors
- SAFe vs Agile: Difference Between Scaled Agile and Agile
- Top 21 Scrum Best Practices for Efficient Agile Workflow
- 30 User Story Examples and Templates to Use in 2025
- State of Agile: Things You Need to Know
- Top 24 Career Benefits of a Certifed Scrum Master
- Most Popular Blogs
- ITIL Certification Cost in 2025 [Exam Fee & Other Expenses]
- Top 17 Required Skills for System Administrator in 2025
- How Effective Is Itil Certification for a Job Switch?
- IT Service Management (ITSM) Role and Responsibilities
- Top 25 Service Based Companies in India in 2025
- Top Picks by Authors
- What is Escalation Matrix & How Does It Work? [Types, Process]
- ITIL Service Operation: Phases, Functions, Best Practices
- 10 Best Facility Management Software in 2025
- What is Service Request Management in ITIL? Example, Steps, Tips
- An Introduction To ITIL® Exam
- Most Popular Blogs
- A Complete AWS Cheat Sheet: Important Topics Covered
- Top AWS Solution Architect Projects in 2025
- 15 Best Azure Certifications 2025: Which one to Choose?
- Top 22 Cloud Computing Project Ideas in 2025 [Source Code]
- How to Become an Azure Data Engineer? 2025 Roadmap
- Top Picks by Authors
- Top 40 IoT Project Ideas and Topics in 2025 [Source Code]
- The Future of AWS: Top Trends & Predictions in 2025
- AWS Solutions Architect vs AWS Developer [Key Differences]
- Top 20 Azure Data Engineering Projects in 2025 [Source Code]
- 25 Best Cloud Computing Tools in 2025
- Most Popular Blogs
- Company Analysis Report: Examples, Templates, Components
- 400 Trending Business Management Research Topics
- Business Analysis Body of Knowledge (BABOK): Guide
- ECBA Certification: Is it Worth it?
- How to Become Business Analyst in 2025? Step-by-Step
- Top Picks by Authors
- Top 20 Business Analytics Project in 2025 [With Source Code]
- ECBA Certification Cost Across Countries
- Top 9 Free Business Requirements Document (BRD) Templates
- Business Analyst Job Description in 2025 [Key Responsibility]
- Business Analysis Framework: Elements, Process, Techniques
- Most Popular Blogs
- Best Career options after BA [2025]
- Top Career Options after BCom to Know in 2025
- Top 10 Power Bi Books of 2025 [Beginners to Experienced]
- Power BI Skills in Demand: How to Stand Out in the Job Market
- Top 15 Power BI Project Ideas
- Top Picks by Authors
- 10 Limitations of Power BI: You Must Know in 2025
- Top 45 Career Options After BBA in 2025 [With Salary]
- Top Power BI Dashboard Templates of 2025
- What is Power BI Used For - Practical Applications Of Power BI
- SSRS Vs Power BI - What are the Key Differences?
- Most Popular Blogs
- Data Collection Plan For Six Sigma: How to Create One?
- Quality Engineer Resume for 2025 [Examples + Tips]
- 20 Best Quality Management Certifications That Pay Well in 2025
- Six Sigma in Operations Management [A Brief Introduction]
- Top Picks by Authors
- Six Sigma Green Belt vs PMP: What's the Difference
- Quality Management: Definition, Importance, Components
- Adding Green Belt Certifications to Your Resume
- Six Sigma Green Belt in Healthcare: Concepts, Benefits and Examples
- Most Popular Blogs
- Latest CISSP Exam Dumps of 2025 [Free CISSP Dumps]
- CISSP vs Security+ Certifications: Which is Best in 2025?
- Best CISSP Study Guides for 2025 + CISSP Study Plan
- How to Become an Ethical Hacker in 2025?
- Top Picks by Authors
- CISSP vs Master's Degree: Which One to Choose in 2025?
- CISSP Endorsement Process: Requirements & Example
- OSCP vs CISSP | Top Cybersecurity Certifications
- How to Pass the CISSP Exam on Your 1st Attempt in 2025?
- More
- Tutorials
- Practise Tests
- Interview Questions
- Free Courses
- Agile & PMP Practice Tests
- Agile Testing
- Agile Scrum Practice Exam
- CAPM Practice Test
- PRINCE2 Foundation Exam
- PMP Practice Exam
- Cloud Related Practice Test
- Azure Infrastructure Solutions
- AWS Solutions Architect
- AWS Developer Associate
- IT Related Pratice Test
- ITIL Practice Test
- Devops Practice Test
- TOGAF® Practice Test
- Other Practice Test
- Oracle Primavera P6 V8
- MS Project Practice Test
- Project Management & Agile
- Project Management Interview Questions
- Release Train Engineer Interview Questions
- Agile Coach Interview Questions
- Scrum Interview Questions
- IT Project Manager Interview Questions
- Cloud & Data
- Azure Databricks Interview Questions
- AWS architect Interview Questions
- Cloud Computing Interview Questions
- AWS Interview Questions
- Kubernetes Interview Questions
- Web Development
- CSS3 Free Course with Certificates
- Basics of Spring Core and MVC
- Javascript Free Course with Certificate
- React Free Course with Certificate
- Node JS Free Certification Course
- Data Science
- Python Machine Learning Course
- Python for Data Science Free Course
- NLP Free Course with Certificate
- Data Analysis Using SQL
- Free Courses
- Home
- Blog
- Software Development
- What is Normalization in DBMS? 1NF, 2NF, 3NF
What is Normalization in DBMS? 1NF, 2NF, 3NF
Updated on Nov 14, 2024 | 7 min read
Share:
Table of Contents
Introduction to Normalisation in DBMS
Structuring data and its attributes in a database is known as database normalisation. Normalisation aims to keep data logically in a database by eradicating data redundancy. Data redundancy makes it challenging for a data administrator to maintain a database. Master normalisation in DBMS by enrolling in the Master of Science in Computer Science from LJMU course today!
Check out our free technology courses to get an edge over the competition.
The Need for Normalisation
Eliminating data redundancy is a necessary process achieved through database normalisation. The ideal reason is to remove anomalies. Persisting anomalies in the database pose a risk to data integrity. Database normalisation consists of a string of guidelines that assist you in structuring a good database.
The reasons mentioned below show why businesses across the globe should normalise their customer data:
Recognise duplication of data
Standardised data makes it significantly easier to discover and combine duplicate customer records. Duplicate records hamper customers’ journeys, which companies may not always be aware of.
Boost marketing segmentation
Database normalisation helps businesses categorise prospects and customers. This, in turn, makes it convenient to target messages. For instance, there is a difference in pitching your solution between a CEO and a CFO.
Enhance lead scoring and routing
Lead scoring refers to providing definite leads or accounts in your CRM value to select the highest possibilities successfully. You require high-quality data for productive lead scoring.
Introduce more data to marketing automation
Marketing plays a significant role in businesses. Your marketing team must be confident of the data they use. They must use accurate data in the information they provide to their clients. Forwarding tailored messages lacking quality or non-normalised data may negatively impact customer experience, ultimately decreasing conversion rates.
Modify redundant data
Normalising the data will help you locate redundant data by aggregating the same fields with similar meanings. Once it recognises duplicate data, it integrates them to eliminate confusion.
Take care of integrated apps
Database normalisation enables the smooth operation of third-party apps and integrations. Normalising helps format the data as per the specific app to function well with the software.
There are generally four types of normal forms in DBMS used. Read on to learn about the first, second, and third normal forms in database normalisation.
Check Out upGrad’s Software Development Courses to upskill yourself.
First Normal Form (1NF)
In 1NF, every attribute of a relation must be a single-valued attribute. A relation in 1NF does not consist of any composite or multi-valued attribute. The existence of a composite or multi-valued attribute breaches the 1NF. This means that atomic values must be present at the meeting point of two rows or columns.
To put it simply, here is an example. Let’s consider a table consisting of columns for names and contact numbers. In such cases, each entry for a name must only have one contact number for it to be in the first normal form.
Second Normal Form (2NF)
In 2NF, partial dependency in DBMS is eliminated among the 1NF relations. This means that a relation will be in 2NF when it is in 1NF with the non-key attributes fully functional and dependent on the primary key. A relational table can be considered to be in second normal form if it follows two conditions. The first condition is that the table must be in regular form. The second condition is that it must completely depend on the primary key without partial dependencies.
Third Normal Form (3NF)
In 3NF, transitive dependency in DBMS is eliminated. This means a relation will be in 3NF when it is in 2NF without any existing transitive dependency. Transitive dependency divides the table to eliminate the transitively dependent attributes. It enables us to place the attributes with a copy of the determinant in a new table.
A relational table can be considered to be in the third normal if it follows the rules enumerated below:
- The table must be in 2NF.
- There is no existence of transitive dependency between a non-prime attribute and the primary key.
- If we consider X and Z in a functional dependency, then X must be a super key of the table, or Z must be a prime attribute of the table.
Full Stack Software Development Bootcamp is the right course for you if you wish to establish a successful career in software development and learn the basics of data science.
Explore our Popular Software Engineering Courses
The Process of Normalisation With Examples
You need to know how it works to clarify further the concept of the first, second and third normalisation types in DBMS. Let’s say you are building a student management application for a course. The illustrated example will give you an extensive idea of the process of database normalisation:
For 1NF
Student code | Student Name | Student Contact Number |
101 | Ranveer | 3682865483, 202835826 |
102 | Sam | 69873897879 |
103 | Manav | 63683267867 |
In the above table, the <Student Contac Number> is a multivalued characteristic. Hence, we can say that it is not in 1NF.
To turn it into 1NF, we need to add new rows for each student’s phone number:
Student Code | Student Name | Student Contact Number |
101 | Ranveer | 3682865483 |
101 | Ranveer | 202835826 |
102 | Sam | 69873897879 |
103 | Manav | 63683267867 |
For 2NF
Student Code | Project ID | Student Name | Project Name |
101 | P03 | Ranveer | project103 |
101 | P02 | Ranveer | project104 |
102 | P01 | Sam | project101 |
103 | P04 | Manav | project102 |
To eliminate the partial dependencies in the above table and turn it into 2NF, segregate it into the following three separate tables:
Student Code | Student Name |
101 | Ranveer |
101 | Ranveer |
102 | Sam |
103 | Manav |
<StudentProject>
Student Code | Project ID |
101 | P03 |
101 | P02 |
102 | P01 |
103 | P04 |
<ProjectDetail>
Project ID | Project Name |
P03 | project103 |
P02 | project104 |
P01 | project101 |
P04 | project102 |
For 3NF
Student Code | Student Name | Student Zipcode | Student City |
101 | Ranveer | 110033 | Model Town |
101 | Ranveer | 110044 | Badarpur |
102 | Sam | 110064 | Hari Nagar |
103 | Manav | 110028 | Naraina |
To eliminate transitive dependency in the above table and to turn it into 3NF. We can divide it into two separate tables:
Student Code | Student Name | Student Zipcode |
101 | Ranveer | 110033 |
101 | Ranveer | 110044 |
102 | Sam | 110064 |
103 | Manav | 110028 |
<StudentLocation>
Student Zipcode | Student City |
110033 | Model Town |
110044 | Badarpur |
110064 | Hari Nagar |
110028 | Naraina |
Advantages of Normalisation
A few advantages of normalisation in DBMS are mentioned below:
- It helps to lessen the chances of data redundancy
- It organises data to give a better structure
- It maintains data consistency
- It designs the database in a much more flexible manner
- It enforces the concept of relational integrity
Disadvantages of Normalisation
A few disadvantages of normalisation in DBMS are:
- You must know the user’s needs to structure a database.
- Normalising the relations to higher normal forms (4NF, 5NF) deteriorates the performance.
- Normalising relations to a higher degree can be complex and take longer.
- Carelessness in decomposing data may result in poor database design, leading to serious issues.
Explore Our Software Development Free Courses
Comparison Between Normalisation and Denormalisation
The table below discusses the factors distinguishing normalisation from denormalisation in DBMS:
Factor | Normalisation | Denormalisation |
Implementation | Normalisation eliminates data redundancy and stores consistent data. | Denormalisation adds some redundant data to a normalised database to refine the database execution time. |
Objective | The main objective of normalisation is to reduce data redundancy. | The main objective of denormalisation is to improve the execution of the database by implementing redundancy. |
Tables | As data is reduced in normalisation, there is also a decrease in the number of tables | As data is increased in denormalisation, there is an increase in the number of tables. |
Consumption of memory | Normalisation reduces data, optimising the memory. | Denormalisation introduces extra data. Hence, it creates memory wastage. |
Data integrity | Normalisation preserves data integrity by adding or deleting mismatched data in the table relationship. | Data integrity is not maintained in denormalisation. |
Conclusion
When data redundancy is eliminated from a database, it optimises the overall performance. This blog illustrates the concepts of normalisation in DBMS to give you an idea of how data redundancy works in a database. It is important to note that most tables do not usually exceed the 3NF limit. However, it is possible to stretch them to 4NF and 5NF depending on your needs and data size.
Enrol in Executive Post Graduation Programme in Full Stack Development From IIITB to kickstart a career in software development. The programme spans 13 months, with top-notch faculty teaching the fundamentals of the field. The curriculum covers all the elements of software development and database management system. Head to the website to know more.
Explore Popular DBMS Tutorials
Frequently Asked Questions (FAQs)
1. What is the main objective of normalisation?
2. Why is database normalisation important?
3. What role does normalisation play in machine learning?
Get Free Consultation
By submitting, I accept the T&C and
Privacy Policy
India’s #1 Tech University
Executive PG Certification in AI-Powered Full Stack Development
77%
seats filled
Top Resources