Top Posts
Java Database Connectivity with MySQL
ISDN: Integrated Services Digital Network
Network Interface
Differences between the OSI and TCP/IP model
TCP/IP Model
What is Routing? | Types of Routing |...
Routing algorithm
Python List
Python Operators
Life cycle of a thread in Java
TECHARGE
  • HOME
  • BLOGS
  • TUTORIALS
    • ALL TUTORIALS
    • PROGRAMMING TUTORIALS
      • JAVA TUTORIALS
      • C++ TUTORIAL
      • C PROGRAMMING TUTORIALS
      • PYTHON TUTORIAL
      • KNOWLEDGE MANAGEMENT TUTORIALS
      • DATA STRUCTURE AND ALGORITHM TUTORIALS
      • PROGRAMMING EXAMPLES
        • CPP EXAMPLES
        • JAVA EXAMPLES
        • C++ GRAPHICS PROGRAM
    • PROJECTS
      • PYTHON PROJECTS
      • SWIFT PROJECT
    • PPROGRAMMING QUIZ
    • DBMS TUTORIALS
    • COMPUTER NETWORK TUTORIALS
    • COMPUTER NETWORK SECURITY TUTORIALS
    • E COMMERCE TUTORIALS 
    • AWS TUTORIAL
    • INTERNET OF THINGS
    • CHEATSHEET
  • MORE
    • JOBS AND INTERNSHIPS
    • INTERVIEW PREPARATION
    • TECH BOOK
    • TECH NEWS
    • UNIVERSITY PAPERS
    • MNC TWEETS
    • THINKECO INITIATIVES
    • CONTACT US
  • WRITE +
  • ABOUT US
  • HIRE US
Dbms Tutorials

Normalization in DBMS

by anupmaurya April 14, 2022
written by anupmaurya 0 comment 1016 views
  • Normalization is the process of organizing the data in the database. It is used to reduce redundancy from a relation or set of relations.
  • It is also used to eliminate the abnormalities of Insertion, Update, and Deletion.
  • Normalization divides the larger table into the smaller table and links them using relationships.

Here are type of normal forms:

Normal Form
Types of Normal Form
  • First normal form(1NF)
  • Second normal form(2NF)
  • Third normal form(3NF)
  • Boyce & Codd normal form (BCNF)
Normal FormDescription
1NFA relation is in 1NF if it contains an atomic value (not having multiple-valued attributes).
2NFA relation will be in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key.
3NFA relation will be in 3NF if it is in 2NF and no transition dependency exists.
4NF /BCNFA relation will be in 4NF if it is in Boyce Codd normal form and has no multi-valued dependency.
Normal Form

Now ,we understand each of normal form with example

First normal form (1NF)

As per the rule of first normal form, an attribute (column) of a table cannot hold multiple values. It should hold only atomic values.

Example: Suppose a College wants to store the names and contact details of its student. It creates a table that looks like this:

Stud_idStud_nameStud_addressStud_mobile
101MansiNew Delhi8912314353
102SachinKanpur88990001222
76452343234
103KomalMumbai77345436544
94653565355
104AryanBangalore343123450987
Table Not in 1NF

Two Student (Komal & Sachin) are having two mobile numbers so the college stored them in the same field as you can see in the table above.

This table is not in 1NF as the rule says “each attribute of a table must have atomic (single) values”, the emp_mobile values for employees Sachin & Komal violates that rule.

To make the table complies with 1NF we should have the data like this:

Stud_idStud_nameStud_addressStud_mobile
101MansiNew Delhi8912314353
102SachinKanpur88990001222
102SachinKanpur76452343234
103KomalMumbai77345436544
103KomalMumbai94653565355
104AryanBangalore343123450987
Table in 1NF

Here in above table (Stud_id and Stud_mobile) combined together to act as PRIMARY KEY, which is an example of Composite Primary key.

To know about more

  • Second normal form(2NF)
  • Third normal form(3NF)
  • Boyce & Codd normal form (BCNF)

DBMSdeletioninsertionnormalisationupdate
Share
4
FacebookTwitterLinkedinRedditWhatsappTelegramEmail
anupmaurya

Hey there, My name is Anup Maurya. I was born with love with programming and works at TCS. One of best global (IT) services and consulting company as System Administrator . I also love graphics designing. It's my pleasure to have you here.

previous post
Boyce Codd normal form (BCNF)
next post
OOPs Concepts in Java

You may also like

DBMS Interview Questions

Functional Dependency

Boyce Codd normal form (BCNF)

Third Normal form (3NF)

Second Normal Form (2NF)

SQL Tutorial

Entity Relationship Diagram – ER Diagram in DBMS

Relational DBMS

Difference between DBMS and File System

Database Models in DBMS

DBMS TUTORIAL

  • DBMS Introduction
  • Relational DBMS
  • DBMS Architecture and Data Abstraction
  • Data Abstraction
  • Different types of Database Users
  • Characteristics of DBMS
  • Types of database utilities and its functions
  • DBMS Functions
  • Relational Model Concepts
  • Difference between DBMS and File System
  • Entity Relationship Diagram – ER Diagram in DBMS
  • Functional Dependency
  • Normalization in DBMS
  • Closure in DBMS | How to Find Closure
  • Second Normal Form (2NF)
  • Third Normal form (3NF)
  • Boyce Codd normal form (BCNF)
  • Transaction in DBMS
  • Transaction property
  • States of Transactions
  • Indexing in DBMS
  • Hashing in DBMS
  • Schedule in DBMS
  • Concurrency Control in DBMS
  • Lock Based Protocols in DBMS
  • Serializability in DBMS
  • Indexed sequential access method (ISAM)
  • DBMS Interview Questions

Words from Readers

Its a very pleasant environment to be on a very interactive learning platform which helps me to enhance my skill set to move forward in an IT marathon.

–Akash Raj

SQL Tutorial

  • SQL Introduction
  • SQL Datatypes
  • SQL Commands

Recent Posts

  • Java Database Connectivity with MySQL

    May 29, 2022
  • ISDN: Integrated Services Digital Network

    May 28, 2022
  • Network Interface

    May 28, 2022

EDUCATIONAL

  • PyScript: Python in the Browser

  • Best Fake Email Generators (Free Temporary Email Address)

  • How to Find Out Who Owns a Domain Name

  • Mobile phone brands by country of origin

  • Best way to use google search you won’t believe exist

  • 10 mostly asked questions related to WhatsApp

  • Top 8 Programming Languages That Will Rule in 2022

  • Google Cloud Platform

  • Best Online Code Editors For Web Developers

  • How to Write a Synopsis for Project Work

CHEATSHEET

  • Git and Github 2022 Cheat Sheet

  • ReactJs Cheatsheet

  • Linux Commands Cheat Sheet

  • C Programming language Cheatsheet

  • Scala Cheatsheet

  • MySQL Cheatsheet

  • Javascript Cheatsheet

PROJECTS

  • Python Rock Paper Scissors Game

  • Currency Converter in Python

  • Alarm clock GUI application with tkinter

  • Print emojis using python without any module

  • Country Date and Time using Python

  • Covid-19 Tracker Application Using Python

  • Python | GUI Calendar using Tkinter

  • Python: Shutdown Computer with Voice

  • Python GUI Calculator using Tkinter

  • Convert an Image to ASCII art using Python

  • Python YouTube Downloader with Pytube

  • Tic-Tac-Toe using Python

TUTORIALS

  • JAVA TUTORIAL
  • COMPUTER NETWORK
  • DBMS TUTORIAL
  • E-COMMERCE TUTORIAL
  • KNOWLEDGE MANAGEMENT
  • C++ PROGRAMMING
  • COMPUTER NETWORK SECURITY
  • AMAZON WEB SERVICES

TECH NEWS

  • PyScript: Python in the Browser

  • HalloApp is a secure alternative to WhatsApp, made by two early WhatsApp employees

  • 5+ Best Humanoid Robots In The World

  • Windows 11 Now Official, Brings Fresh UI, Centrally-Placed Start Menu

TERMS & POLICY

  • PRIVACY POLICY
  • TERMS AND CONDITIONS

COMPILERS

  • JAVA COMPILER
  • PYTHON COMPILER
  • JS COMPILER
  • C++ COMPILER
  • C COMPILER

JOBS AND INTERNSHIPS

  • TCS off-campus hiring 2022 for software engineers- 2019, 2020, & 2021 Batches

    February 27, 2022
  • Deloitte Recruitment For Any Graduates as Learning Operations Associate Analyst

    February 18, 2022
  • HP Recruitment For Tech Support Intern Position

    February 16, 2022
  • EY Hiring- PAS Global Immigration Advanced Analyst

    February 14, 2022
  • Amazon Recruitment Drive for Virtual Customer Support Associate Position

    February 12, 2022

@2019-21 - All Right Reserved. Designed and Developed by Techarge

TECHARGE
  • HOME
  • BLOGS
  • TUTORIALS
    • ALL TUTORIALS
    • PROGRAMMING TUTORIALS
      • JAVA TUTORIALS
      • C++ TUTORIAL
      • C PROGRAMMING TUTORIALS
      • PYTHON TUTORIAL
      • KNOWLEDGE MANAGEMENT TUTORIALS
      • DATA STRUCTURE AND ALGORITHM TUTORIALS
      • PROGRAMMING EXAMPLES
        • CPP EXAMPLES
        • JAVA EXAMPLES
        • C++ GRAPHICS PROGRAM
    • PROJECTS
      • PYTHON PROJECTS
      • SWIFT PROJECT
    • PPROGRAMMING QUIZ
    • DBMS TUTORIALS
    • COMPUTER NETWORK TUTORIALS
    • COMPUTER NETWORK SECURITY TUTORIALS
    • E COMMERCE TUTORIALS 
    • AWS TUTORIAL
    • INTERNET OF THINGS
    • CHEATSHEET
  • MORE
    • JOBS AND INTERNSHIPS
    • INTERVIEW PREPARATION
    • TECH BOOK
    • TECH NEWS
    • UNIVERSITY PAPERS
    • MNC TWEETS
    • THINKECO INITIATIVES
    • CONTACT US
  • WRITE +
  • ABOUT US
  • HIRE US