Submitted Questions

  • Briefly explain the difference between first, second, third and fourth normal forms?

    anbum

    • Oct 17th, 2007

    Normalization is based on the functional dependency and primary key.1NF- Attribute should be atomic value and there must be no composite attribute, no multivalued attribute and no relation with in re...

    bhawesh

    • Jul 19th, 2007

    First NF---Attribute should be atomic an no redundant row. (functional dependancy) Second Normal Form : All Non-Key attribute should be fully functionally dependent on primary key.(removes partial dependancy)Third normal Form : There is no transitivity dependency between attribute.