adspace


what are the different type of normalization? : Sql dba

Answer Posted / Siddharth Verma

Normalization in SQL is a process to organize data in a relational database to minimize redundancy and dependency. There are three normal forms: First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). 1NF eliminates repeating groups, 2NF eliminates partial dependencies, and 3NF eliminates transitive dependencies.

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 bcp? When does it used? : Sql dba

1065


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

1252


What is the current version of sql?

1106


Can we use distinct and group by together?

1146


what is collation? : Sql dba

1242


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

1124


What is the best sql course?

1062


What is your daily office routine?

2351


what are all the common sql function? : Sql dba

1141


what are aggregate and scalar functions? : Sql dba

1142


what is dbms? : Sql dba

1070


Do we need to rebuild index after truncate?

1151


Is inner join faster than left join?

1287


Can delete statement be rollbacked?

1065


what are the advantages of sql ? : Sql dba

1154