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
- 5761 Views
- I also Faced
- E-Mail 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 |
Explain storage manager?
How can we join three tables in SQL server 2000
What is dialect in database?
What is the importance of database partitioning?
Explain file manager?
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 different types of resources?
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
What does new grouping sets enables you to do?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
How to do Data size testing? Who does this testing (Developer or tester)?
-
Oracle (3259) - 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)
