What is normalization and types of normalization?

Answer Posted / r.arjunarao

Normalization means reduces redundancy unnecessary
repetition of data is NF
UnNormalization means intentional introduction redundancy to
a table to improve the performance is De-NF or Un-NF
1NF Any multiple values Attribute have been removed.
2NF Any partial functionality dependency have been removed.
3NF Any transitive functionality dependency have been removed.
4NF Any multi-values dependency have been removed.
5NF Any remaing anomalies have been removed.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does trigger mean in psychology?

624


What is the difference between sum and count in sql?

610


what is the functionality of the function htmlentities? : Sql dba

602


What is a sql statement?

615


What is use of term?

716






how can we find the number of rows in a table using mysql? : Sql dba

682


What is column?

622


What are expressions?

654


Is it important to partition hard disk?

638


how many ways to get the current time? : Sql dba

613


What is the use of non clustered index?

613


What is sql in java?

635


Why left join is used in sql?

629


What are aggregate functions in sql?

744


define join and explain different type of joins? : Sql dba

641