normalization

expalin in detail the diferences between the first and second normal forms?

Follow this [URL="http://databases.about.com/od/specificproducts/a/firstnormalform.htm"]link[/URL]

[U]First Normal Form[/U]:The domain of attribute must include only atomic (simple, indivisible) values.
[U]Second Normal Form[/U]:A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

what is normalization

In simple words it is a way for designing database tables to minimize duplication of data.
Database developers have introduce some guidelines for ensuring that databases are normalized. These are referred to as normal forms and they are called as first normal form, second normal form etc.

Thanks.

hi,

Please refer to [url=http://en.wikipedia.org/wiki/Database_normalization#First_normal_form]Database normalization - Wikipedia, the free encyclopedia[/url], gives you all the information. Please dont hesitate to post your queries after going through this

Thanks
Sushma