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
How can I see all tables in sql?
How do you select unique values in sql?
What is pl sql block structure?
what are the properties and different types of sub-queries? : Sql dba
What are procedures used for?
What is primary key secondary key alternate key candidate key?
Why stored procedure is faster than query?
Why primary key is required?
What is lexical units in pl sql?
What are the types of operators available in sql?
What are the 3 types of behavioral triggers?
how to return query output in html format? : Sql dba
How to run sql statements through the web interface?
How delete all data from all tables in sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?