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 is asqueryable?
What is pls_integer in pl sql?
What is sql stand for?
What view means?
What is auto increment?
Which join is like inner join?
Explain the uses of a database trigger?
How can we avoid duplicating records in a query?
What is sql architecture?
Does normalization improve performance?
How do I tune a sql query?
Is time a data type in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
In what condition is it good to disable a trigger?
Can we use two order by clause in query?