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
Will truncate release space?
Which query operators in sql is used for pattern matching?
Is left join faster than inner join?
What is restrict in sql?
Is a view faster than a stored procedure?
What makes a good primary key?
Write a query to find the names of users that begin with "um" in sql?
Define a temp table?
What are the constraints available in sql?
What are some predefined exceptions in pl/sql?
Can we create clustered index without primary key?
How do you update a value in sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
define sql update statement ? : Sql dba
What is a database trigger?