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 sql performance tuning?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Write a sql query to find the names of employees that begin with ‘a’?
What is a primary key sql?
What is trigger and how to use it in sql?
what is the command line end user interface - mysql? : Sql dba
Is sql scripting language?
What are the triggers associated with image items?
what is recursive stored procedure? : Sql dba
what are integrity rules?
How do I save a sql query?
Why join is faster than subquery?
Which certification is best for sql?
What is sql partition function?
What is a loop in sql?