What is normalisation and its types?



What is normalisation and its types?..

Answer / Deepak Maurya

Normalisation is a process used in database design to organize data in a logical and efficient manner. It aims to eliminate data redundancy, improve data integrity, and make the database easier to understand and manage. Normalisation has several stages (or 'normal forms'), each with its own set of rules for organizing data: first normal form (1NF), second normal form (2NF), third normal form (3NF), fourth normal form (4NF), and fifth normal form (5NF).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How do I install sql?

1 Answers  


What is the use of pl/sql table?

1 Answers  


Explain exception handling in pl/sql?

1 Answers  


Mention what are the benefits of pl/sql packages?

1 Answers  


What are the most important characteristics of pl/sql?

1 Answers  


how to findout the 100th maximum salary

28 Answers   Amdocs,


how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1 Answers  


Why do we go for stored procedures?

1 Answers  


Is left join same as inner join?

1 Answers  


Does inner join remove duplicates?

1 Answers  


How long does it take to learn pl sql?

1 Answers  


Categories