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 are the different type of sql's statements ? : Sql dba
What is procedure function?
how to analyze tables with 'mysqlcheck'? : Sql dba
Does execute immediate commit?
How many triggers can be applied to a table?
Can we insert in view in sql?
Does sql use python?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is not in sql?
How do I run a script in sql developer?
How to read/write files from pl/sql?
what is view? : Sql dba
How do I quit sql?
what is an extent ? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql