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
- 5844 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 |
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What are the advantages of normalizing a database.
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
How to do performance tunning a database in DB2 V8.2 UDB in linux
what is data access layer?
What is the role of driver manager?
issues involved in modeling and building data werahouses
Differentiate between unique key and foreign key?
Datatypes are unlimited,true or false?
what is the difference between tuple calculus and domain calculus ?
List the properties of a transaction.
What are different types of joins used in?
-
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)
