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
- 5904 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
Explain database partitioning.
What are the tools used for backup and ticketing?
How do database connections work?
What are the advantages of normalizing a database.
How do I manually create a database?
How many types of normalization? What is the use of it?
What is the purpose of TNS?
Under which circumstance should you create an index on a table?
Is storing images in a database a good idea?
What are the various ways to execute a query in teradata?
Differentiate between extension & intension?
What is the candidate key used for?
What is a database lookup?
How to shrink a database?
What happens when shared and exclusive locks are applied on data item?
