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
- 5759 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
What is a driver in database?
What are different types of blocks used in stored procedure?
What is the role of driver manager?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What is database and its types?
What is redis good for?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
What is aws documentdb?
What is a Database?
What are the disadvantages of views in a database?
How heap is implemented in database?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
What are different types of resources?
What is the importance of database partitioning?
