can any one explain about normalization forms with clear
explanation in interview point of view.
thanks for ur answers.
Answer Posted / ajeet khari
normalization is organizing data efficiently into database...
main thing is 1.elimination of redundant data,2. data
dependencies..
1NF-a table is decomposed into 2D table with no duplicate
column....
2nd NF- should be in 1NF and there should not be any
duplicate row...
3NF- should be in 2NF and contains transitive dependencies
remove that column which are not dependent on PK.
4NF-should be in 3NF and it has no malti valued dependencies.
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are database connection details?
Which is the best graph database?
What is a database example?
how node connect with cpu?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
Explain phantom deadlock?
Which database is best to store images?
Explain alternate key?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
What is the difference between primary and candidate key?
How does non-cluster index functions?
What is ase database?
Is database a hardware or software?
what is tkprof tool and how it is used???
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?