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
What does trigger mean in psychology?
What is the difference between sum and count in sql?
what is the functionality of the function htmlentities? : Sql dba
What is a sql statement?
What is use of term?
how can we find the number of rows in a table using mysql? : Sql dba
What is column?
What are expressions?
Is it important to partition hard disk?
how many ways to get the current time? : Sql dba
What is the use of non clustered index?
What is sql in java?
Why left join is used in sql?
What are aggregate functions in sql?
define join and explain different type of joins? : Sql dba