What are the four 4 types of database normalization?
Emma Martin
Published Feb 25, 2026
What are the four 4 types of database normalization?
The database normalization process is further categorized into the following types:
- First Normal Form (1 NF)
- Second Normal Form (2 NF)
- Third Normal Form (3 NF)
- Boyce Codd Normal Form or Fourth Normal Form ( BCNF or 4 NF)
- Fifth Normal Form (5 NF)
- Sixth Normal Form (6 NF)
What are the various forms of Normalisation?
Normalization
- First normal form(1NF)
- Second normal form(2NF)
- Third normal form(3NF)
- Boyce & Codd normal form (BCNF)
What are the 3 types of normal forms?
There are three stages of normal forms are known as first normal form (or 1NF), second normal form (or 2NF), and third normal form (or 3NF).
What are the 3 normal forms in DBMS?
Normal Forms in DBMS
- First Normal Form – If a relation contain composite or multi-valued attribute, it violates first normal form or a relation is in first normal form if it does not contain any composite or multi-valued attribute.
- Second Normal Form –
- Third Normal Form –
- Boyce-Codd Normal Form (BCNF) –
How many normalization forms are there?
There are six normal forms, but we will only look at the first four, which are: First normal form (1NF) Second normal form (2NF) Third normal form (3NF)
Why is 2NF used?
Second normal form (2NF) is a normal form used in database normalization. A relation is in the second normal form if it fulfills the following two requirements: It is in first normal form. It does not have any non-prime attribute that is functionally dependent on any proper subset of any candidate key of the relation.
What is normalization and what are the different types of normalization?
Normalization is used to minimize the redundancy from a relation or set of relations….Types of Normal Forms.
| Normal Form | Description |
|---|---|
| 3NF | A relation will be in 3NF if it is in 2NF and no transition dependency exists. |
| 4NF | A relation will be in 4NF if it is in Boyce Codd normal form and has no multi-valued dependency. |
What is normalization and types of normalization?
Normalization is the process of organizing data into a related table; it also eliminates redundancy and increases the integrity which improves performance of the query. Database normalization can essentially be defined as the practice of optimizing table structures.
What is normalization in DBMS and its different forms?
Normalization is the process of organizing the data in the database….Types of Normal Forms.
| Normal Form | Description |
|---|---|
| 2NF | A relation will be in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key. |
| 3NF | A relation will be in 3NF if it is in 2NF and no transition dependency exists. |
What is 1st 2nd and 3rd normal form?
A relation is in second normal form if it is in 1NF and every non-key attribute is fully functionally dependent on the primary key. A relation is in third normal form if it is in 2NF and there are no dependencies between non-key attributes. (i.e. 2NF + no transitive dependencies).
What is 2NF example?
Example (Table violates 2NF) The prime key attributes are StudentID and ProjectID. As stated, the non-prime attributes i.e. StudentName and ProjectName should be functionally dependent on part of a candidate key, to be Partial Dependent.
What is 2nd normal form in DBMS?
