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
Explain how to use transactions efficiently : transact sql
What does sql stand for?
what is the difference between sql and t-sql? : Transact sql
What does the acronym acid stand for in database management?
What is sqlerrd?
What is pivot table in sql?
Which is the correct statement about truncate and delete?
what are the advantages a stored procedure? : Sql dba
how many values can the set function of mysql take? : Sql dba
Are pl sql variables case sensitive?
what is the use of double ampersand (&&) in sql queries?
Explain the purpose of %type and %rowtype data types with the example?
What is composite primary key in sql?
What is coalesce sql?
What are the key differences between SQL and PL SQL?