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
- 5832 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
How many indexes can be created on a table?
What is lagging in DBMS ?
What is the importance of database partitioning?
What are different types of data models available? Explain with example?
what is the full procedure for using store procedure in informatica7.1?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What is table scan and index scan?
Explain data independence & its types.
Is database a hardware or software?
Define stored procedure?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
What the various ways to tune a teradata query
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
What is ole db used for?
What is the candidate key used for?
