Discussion about normal forms in SQL

[ronitreddy]

[quote author=galigannarao link=topic=219396.msg2702639#msg2702639 date=1312298226]
@gr33d

now define second normal form with a scenario
[/quote]

mem chebithe nu em chesthav  @3$% @3$% @3$%

[galigannarao]

[quote author=ronitreddy link=topic=219396.msg2702670#msg2702670 date=1312298461]
mem chebithe nu em chesthav  @3$% @3$% @3$%
[/quote]nenu prasna vestunna kada meeru cheppandi @3$% @3$%

[ronitreddy]

[quote author=galigannarao link=topic=219396.msg2702681#msg2702681 date=1312298530]
nenu prasna vestunna kada meeru cheppandi @3$% @3$%
[/quote]

maa thandree..2nf ante koncham gurthu techukovali  sCo_^Y sCo_^Y

[chowdary10]

[quote author=ronitreddy link=topic=219396.msg2702670#msg2702670 date=1312298461]
mem chebithe nu em chesthav  @3$% @3$% @3$%
[/quote]

correstoo kadoo sethaadu, thappu ithe, correst ga sefthaadu  @3$%

gali ba.. dico ayepoyaaka, conclusion ivvu koddiga descriptive ga .. so that confuse avvakunda telusukuntaamu  H&*()
thankyou for the thread

[nenuinthe]

[quote author=KINDAL link=topic=219396.msg2702687#msg2702687 date=1312298610]
correstoo kadoo sethaadu, thappu ithe, correst ga sefthaadu  @3$%

gali ba.. dico ayepoyaaka, conclusion ivvu koddiga descriptive ga .. so that confuse avvakunda telusukuntaamu  H&*()
thankyou for the thread
[/quote]ippudu em nerchukuntunav darling.... &D_@@

[Virat Kohli]

ee thread ayyaka konchem emanna conclusion evvandi baa, naku em telvavu avi yeffudoo sadiva...... konchem telusukunta

Gali  CITI_$D# CITI_$D# CITI_$D# CITI_$D# you rock you rock you rock you rock you rock sHa_clap4 sHa_clap4 sHa_clap4 H&*() H&*() H&*() H&*()

[jamesbond]

nenu SQL lo just simple Select Queries raastha ante.....

Database details anta idea ledu baa

[galigannarao]

Second normal form is valid in a table which have composite primary key which is made with the combination of two columns.So if we have A,B,C,D,E attributes in our table and C,D are fully functional dependent on A,B.But E is partially functional dependent on A,B,Mean if we use Only B to define E coloumn then that will be suffecent.so then we use 2nd normal form & we create two tables with coloumns attributes A,B,C,D and the other table with coloumns attribute B,E.That will be called second normal form.

[K.A.Paul]

maaa java vallani tokeystunaru gaa db lo F@!n

[k2s]

[img]http://www.idlebrain.com/movie/photogallery/porutelangana/images/porutelangana8.jpg[/img]

[galigannarao]

[quote author=K.A.Paul link=topic=219396.msg2702710#msg2702710 date=1312298804]
maaa java vallani tokeystunaru gaa db lo F@!n
[/quote]nee yabba .net ayina java ayina backend sql kavalikadara *7*^ *7*^ *7*^ *7*^

[galigannarao]

[quote author=k2s link=topic=219396.msg2702712#msg2702712 date=1312298820]
[img]http://www.idlebrain.com/movie/photogallery/porutelangana/images/porutelangana8.jpg[/img]
[/quote] *7*^ *7*^ *7*^ *7*^ *7*^

[K.A.Paul]

[quote author=galigannarao link=topic=219396.msg2702716#msg2702716 date=1312298852]
nee yabba .net ayina java ayina backend sql kavalikadara *7*^ *7*^ *7*^ *7*^
[/quote]maku sql avasaram ledu :0012391:

[ladysfinger]

CITI_c$y CITI_c$y  mari Excel use chestaavaaa

[quote author=K.A.Paul link=topic=219396.msg2702728#msg2702728 date=1312298962]
maku sql avasaram ledu :0012391:
[/quote]

[manoghna]

*=: you rock