adspace


What is normalization in sql?

Answer Posted / Naman Gupta

Normalization in SQL is a process of organizing data in a database to minimize redundancy, improve data integrity and dependency, and enhance query performance. There are several levels of normalization (1st, 2nd, 3rd, etc.), each with specific rules for structuring tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key always clustered index?

1101


how to start mysql server? : Sql dba

1279


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

1065


How do I remove duplicates in two columns?

1202


Does group by remove duplicates?

1120


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

1156


what is collation? : Sql dba

1242


what are all the common sql function? : Sql dba

1141


define sql insert statement ? : Sql dba

1110


What is the current version of postgresql?

1188


how to escape special characters in sql statements? : Sql dba

1124


Is primary key clustered index?

1028


what are the advantages of sql ? : Sql dba

1154


What is the best sql course?

1064


what are aggregate and scalar functions? : Sql dba

1142