adspace


What is normalisation and its types?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is your daily office routine?

2351


Is inner join faster than left join?

1287


what is schema? : Sql dba

1163


How do I remove duplicates in two columns?

1202


what is bcp? When does it used? : Sql dba

1065


Can we use distinct and group by together?

1146


What is the current version of postgresql?

1188


how many tables will create when we create table, what are they? : Sql dba

1155


If a cursor is open, how can we find in a pl/sql block?

1252


what are aggregate and scalar functions? : Sql dba

1142


what is collation? : Sql dba

1242


how to use regular expression in pattern match conditions? : Sql dba

1125


how to start mysql server? : Sql dba

1279


Is primary key always clustered index?

1101


what are the advantages of sql ? : Sql dba

1154