What is normalization ?

Answer Posted / seenuvasan.a

It is a process of the analysing the given relation schemas based on their Functional Dependency(FDs) and primary key to achieve the properties,

-> Minimizing redundancy.
-> Minimizing insertion,deletion,and update anomalies.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is an index?

762


Can we join more than 2 tables in sql?

683


What are the different dcl commands in sql?

768


Why do we need cursor in pl sql?

833


What are the different sql commands?

724


What is bind variable in pl sql?

726


What does inner join mean?

759


What is the difference between a procedure and a function?

705


Which is better trigger or stored procedure?

693


What is dml and ddl?

715


What is a heap in sql?

724


What packages are available to pl/sql developers?

814


What is cross join sql?

685


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

845


What is a unique constraint?

811