what is Normalization means..?

Answer Posted / amresh

In simple words process of replacing a relation with more
than one relation so as to come round with problems of bad
database design(i.e redundancy,insertion,updation,deletion
anomalies_---
The three primitive normal forms r
1> 1-nf:asserts that relation with
atomic values.
2> 2-nf:asserts with eliminating partial
dependency.
3> 3-nf:asserts at eliminating
transitive dependency.

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2105


Explain partial key?

658


How do you connect to a database?

611


what is the full procedure for using store procedure in informatica7.1?

1815


How does non-cluster index functions?

654






Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

700


Explain entity type?

631


where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1581


What do you mean by foreign key and primary key?

627


how node connect with cpu?

1671


What advantages does DBMS have over traditional file systems?

597


Which database is best to store images?

534


how can you perform lookup range in lookup stage expalin in detail?

1529


How to shrink a database?

546


How do I manually create a database?

570