The Perfect Mix of Technology & Knowledge
Boyce – Codd Normal Form (BCNF) :- A normal form is said to be a Boyce – Codd Normal Form if it is in 3NF and there is not a possibility of a key attribute is determined by a Non Key attribute. For example , suppose there are 5 columns says A,B,C,D,E and combination of the columns A and … Read more
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following conditions:- 1) It satisfies the condition for the First Normal Form (1NF), 2) It do not includes any partial dependencies where a column is dependent only a part of a primary key. For example suppose we have … Read more
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy the following conditions:- 1) It should be in the 2NF 2) It should not contain any transitive dependency which means that any non key column of the table should not be dependent on another non … Read more
First Normal Form (INF) A table is said to be in a First Normal Form (1NF) if it satisfy the following conditions:- 1)If the columns of the table only contain atomic values (Single, indivisible). 2)Primary key is defined for the table 3)All the columns of the table are defined on the primary key.The first condition … Read more
Database Normalization Normalization Database Normalization can be defined as the process of organization the data to reduce the redundant table data to the minimum. This process is carried out by dividing the database into two or more than two tables and defining relationship between them so that deletion, updation and insertion can be made to … Read more
