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


Please Help Members By Posting Answers For Below Questions

What is flag in sql?

547


What is sql*plus?

575


how to use in conditions? : Sql dba

514


What is java sql connection?

518


What is a composite primary key?

585






How do you take the union of two tables in sql?

517


What is varchar sql?

620


What is the difference between a subquery and a join?

531


Why schema is used in sql?

517


Explain how can you save or place your msg in a table?

597


What are the different types of a subquery?

525


What is data types in sql?

537


What is a schema? How is it useful in sql servers?

595


What is the use of primary key?

539


What is scalar and vector?

534