Discussion about normal forms in SQL

[Antaraatma]

[quote author=galigannarao link=topic=219396.msg2702785#msg2702785 date=1312299456]
2NF

Each attribute must be functionally dependent on the primary key.
Functional dependence - the property of one or more attributes that uniquely determines the value of other attributes.
Any non-dependent attributes are moved into a smaller (subset) table.
2NF improves data integrity.
[/quote] @gr33d @gr33d *=:

[Ranga_The_Donga]

[quote author=jamesbond link=topic=219396.msg2702782#msg2702782 date=1312299434]
idanta soothante bayam estundi baa's..... Nenu maa bengalooru pothaa

edanna sinna udyogam seskunta le  &D_@@ &D_@@

vammo endi idanta......  &*B@ &*B@
[/quote]

take it slow ba.....

e forms evaru patinchukonu avsaram ledhu.......database architect is de responsible person.....

[galigannarao]

3NF

Remove transitive dependencies.
Transitive dependence - two separate entities exist within one table.
Any transitive dependencies are moved into a smaller (subset) table.
3NF  further improves data integrity.
Prevents update, insert, and delete anomalies

[charygaru]

asalu ee normal forms ante endo deni gurinchi matladuku ntunnaro mukk kuda ardham aythaldu naaku  !q# !q# !q# !q# !q# !q#

[ronitreddy]

[quote author=galigannarao link=topic=219396.msg2702785#msg2702785 date=1312299456]
2NF

Each attribute must be functionally dependent on the primary key.
Functional dependence - the property of one or more attributes that uniquely determines the value of other attributes.
Any non-dependent attributes are moved into a smaller (subset) table.
2NF improves data integrity.
[/quote]

idedo google sesina telusthadi kada..koncham tech terms use cheyakunda layman terms lo chepochu kada.. H&*() H&*()

[Antaraatma]

[quote author=galigannarao link=topic=219396.msg2702796#msg2702796 date=1312299509]
3NF

Remove transitive dependencies.
Transitive dependence - two separate entities exist within one table.
Any transitive dependencies are moved into a smaller (subset) table.
3NF  further improves data integrity.
Prevents update, insert, and delete anomalies
[/quote]2NF and 3NF almost same kada baa...  sCo_^Y sCo_^Y naaku epudu confusion untadi renditlo..  sSa_j@il

[manoghna]

[quote author=ronitreddy link=topic=219396.msg2702788#msg2702788 date=1312299473]
oka sql query ni ela tune chestharo kuda cheppandi koncham..performance tune chestharu kada explain plan ala use chesi..dani mida kuda koncham information provide cheyandi plssss..
[/quote] NOrmals forms aipoina tarvatha ..we can discuss Performance tuning... bcos Normalisation ardhamithe then denormalisation ardhamavuthundhi which is a performance tuning

[Ranga_The_Donga]

[quote author=charygaru link=topic=219396.msg2702802#msg2702802 date=1312299554]
asalu ee normal forms ante endo deni gurinchi matladuku ntunnaro mukk kuda ardham aythaldu naaku  !q# !q# !q# !q# !q# !q#
[/quote]

fresh ga DATABASE create cheyali ante.........e forms mindlo pettukoni cheyali...adhi anamata.......

[galigannarao]

[quote author=charygaru link=topic=219396.msg2702802#msg2702802 date=1312299554]
asalu ee normal forms ante endo deni gurinchi matladuku ntunnaro mukk kuda ardham aythaldu naaku  !q# !q# !q# !q# !q# !q#
[/quote]
Normalization

A logical design method which minimizes data redundancy and reduces design flaws.

Consists of applying various “normal” forms to the database design.
The normal forms break down large tables into smaller subsets.

[manoghna]

[quote author=Jeedeelu link=topic=219396.msg2702776#msg2702776 date=1312299377]
\
dependency in a single table elimanate chesi.......

rendo table create chestaru antunna......
[/quote] got it ...

[ladysfinger]

Bangalore aa baa needi  sCo_^Y [quote author=jamesbond link=topic=219396.msg2702782#msg2702782 date=1312299434]
idanta soothante bayam estundi baa's..... Nenu maa bengalooru pothaa

edanna sinna udyogam seskunta le  &D_@@ &D_@@

vammo endi idanta......  &*B@ &*B@
[/quote]

[Ranga_The_Donga]

[quote author=galigannarao link=topic=219396.msg2702812#msg2702812 date=1312299624]
Normalization

A logical design method which minimizes data redundancy and reduces design flaws.

Consists of applying various “normal” forms to the database design.
The normal forms break down large tables into smaller subsets.
[/quote]

naku 3NF example kavali........ardam kala..... cry@fl cry@fl cry@fl

2NF and 3NF mostly same ga vunnayi....

[jamesbond]

[quote author=Jeedeelu link=topic=219396.msg2702795#msg2702795 date=1312299504]
take it slow ba.....

e forms evaru patinchukonu avsaram ledhu.......database architect is de responsible person.....
[/quote]
yeah ade anukuntanna.... I never came across these

Probably database developer use chestaaremo... memedo chinna analyst lam  @3$%

[galigannarao]

[quote author=ronitreddy link=topic=219396.msg2702807#msg2702807 date=1312299590]
idedo google sesina telusthadi kada..koncham tech terms use cheyakunda layman terms lo chepochu kada.. H&*() H&*()
[/quote]sare ayte kasuko

[jamesbond]

[quote author=Luv Guru link=topic=219396.msg2702826#msg2702826 date=1312299743]
Bangalore aa baa needi  sCo_^Y
[/quote]
namma Bengalooru huduga :P