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
Under which circumstance should you create an index on a table?
What is Data Modelling?
What are different types of joins used in?
What is the best database?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What are the advantages of views in a database?
Explain about ur projets on teradata???
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
Explain normalization in one line?
What is a Database?
What is the difference between data source and database?
What is the best database software for small businesses?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
How do database connections work?
Is data lake a database?