can any one explain about normalization forms with clear
explanation in interview point of view.
thanks for ur answers.
Answer / 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 |
Is storing images in a database a good idea?
How can we join three tables in SQL server 2000
What is the main difference b/w Teradata and Oracle?
What do you mean by database?
What is OQL?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
in informatica workflow has 5 sessions and running seqentially and 3rd session has been failed how can we run again from only 3rd to 5th session
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
Which is the best sorting method if i have to sort the students of Harvard University according to their first name?
what is the difference between tuple calculus and domain calculus ?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
Is hive a database?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)