Interested to Buy Any Domain ? << Click Here >> for more details...
can any one explain about normalization forms with clear
explanation in interview point of view.
thanks for ur answers.
- 1 Answers
- 5822 Views
- I also Faced
- E-Mail 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
After normalization, what are the conditions which have to keep in mind to de-normalize it?
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
What are the disadvantages of views in a database?
How to do Data size testing? Who does this testing (Developer or tester)?
how can we view column head in first page but not in remaining pages?
What advantages does DBMS have over traditional file systems?
What are the advantages of using database?
Explain phantom deadlock?
What is relational database with example?
Why do we need distributed database?
Explain buffer manager?
What is the role of tester in discovery(in Checklist)?
Is it good to store images in database?
Which database does facebook use?
What is the difference between primary key, foreign key and candidate key?
