Jump to content

Discussion about normal forms in SQL


Recommended Posts

Posted

[quote author=Jeedeelu link=topic=219396.msg2702932#msg2702932 date=1312300617]
Next tofic denimeedha..... sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y
[/quote]discussion will be continued after lunch. antavaraku vechi chudandi H&*() H&*() H&*() H&*()

  • Replies 198
  • Created
  • Last Reply

Top Posters In This Topic

  • galigannarao

    40

  • Ranga_The_Donga

    22

  • manoghna

    22

  • ronitreddy

    17

Top Posters In This Topic

Posted

[quote author=jamesbond link=topic=219396.msg2702938#msg2702938 date=1312300685]
Ammugif Ammugif
[/quote]

oota madiya  sCo_^Y sCo_^Y sCo_^Y sCo_^Y

Posted

[quote author=meghana9 link=topic=219396.msg2702903#msg2702903 date=1312300395]
After 2nd normal form you have to look ,if they are any dependencies in the same table, for example : if the table contains
emp name,city and zipcode in the 2nd normal form... city is dependent on zipcode kada.. so avi rendu same table lo undakudadhu you have to create separates tables with emp name and city as columns in one table and emp name and zipcode as columns in another table... now e two tables ki primary and foriegn key relationship create cheyali...
ila konni tables ki relation lekunda vuntayi vatini remove cheyali.. ade 3rd normal form ante...

In brief: 2nd normal ni inka separate cheyali more tables ga ,and primary,foriegn key relationship leni tables ni remove cheyali
[/quote] sHa_clap4 sHa_clap4 sHa_clap4 sHa_clap4 you rock you rock you rock

Posted

[quote author=galigannarao link=topic=219396.msg2702941#msg2702941 date=1312300700]
discussion will be continued after lunch. antavaraku vechi chudandi H&*() H&*() H&*() H&*()
[/quote]

next topic [b]Security in Dotnet[/b] Gurinchi matladukundham baaa. Interview lo Den**ru aa topic meedhaa

Posted

[quote author=galigannarao link=topic=219396.msg2702941#msg2702941 date=1312300700]
discussion will be continued after lunch. antavaraku vechi chudandi H&*() H&*() H&*() H&*()
[/quote]topic cheppi vellu ,I will continue  sCo_^Y

@Virat,Gali,Kaaki  thankyou

Posted

[quote author=pulithoka link=topic=219396.msg2702953#msg2702953 date=1312300799]
next topic [b]Security in Dotnet[/b] Gurinchi matladukundham baaa. Interview lo Den**ru aa topic meedhaa
[/quote]vakey baa but aa disco taruvata ivala sqlki ankitam ichedam H&*()

Posted

[quote author=galigannarao link=topic=219396.msg2702941#msg2702941 date=1312300700]
discussion will be continued after lunch. antavaraku vechi chudandi H&*() H&*() H&*() H&*()
[/quote]

deni medho seppi ellu.......elopala ground wrk sesukunta..... F%G_@ F%G_@ F%G_@

Posted

[quote author=Virat Kohli link=topic=219396.msg2702944#msg2702944 date=1312300723]
oota madiya  sCo_^Y sCo_^Y sCo_^Y sCo_^Y
[/quote]

thindi thinnara ??

Posted

[quote author=Jeedeelu link=topic=219396.msg2702958#msg2702958 date=1312300895]
deni medho seppi ellu.......elopala ground wrk sesukunta..... F%G_@ F%G_@ F%G_@
[/quote]cursors and types of cursors &D_@@ &D_@@ &D_@@ &D_@@

Posted

[quote author=meghana9 link=topic=219396.msg2702903#msg2702903 date=1312300395]
After 2nd normal form you have to look ,if they are any dependencies in the same table, for example : if the table contains
emp name,city and zipcode in the 2nd normal form... city is dependent on zipcode kada.. so avi rendu same table lo undakudadhu you have to create separates tables with emp name and city as columns in one table and emp name and zipcode as columns in another table... now e two tables ki primary and foriegn key relationship create cheyali...
ila konni tables ki relation lekunda vuntayi vatini remove cheyali.. ade 3rd normal form ante...

In brief: 2nd normal ni inka separate cheyali more tables ga ,and primary,foriegn key relationship leni tables ni remove cheyali
[/quote] you rock you rock thankyou thankyou thankyou S%Hi S%Hi S%Hi

Posted

[quote author=charygaru link=topic=219396.msg2702959#msg2702959 date=1312300899]
thindi thinnara ??
[/quote] CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D#

Posted

[quote author=galigannarao link=topic=219396.msg2702965#msg2702965 date=1312301035]
cursors and types of cursors &D_@@ &D_@@ &D_@@ &D_@@
[/quote]

habba oddu baa cursors antene bhayam  cry@fl cry@fl cry@fl

denormalization gurinchi cheppochu kada

Posted

[quote author=galigannarao link=topic=219396.msg2702965#msg2702965 date=1312301035]
cursors and types of cursors &D_@@ &D_@@ &D_@@ &D_@@
[/quote]cursors ipudu use chetshunnara ? adhi ekuva use cheyaru... it slowers the performance of the database

Posted

[quote author=galigannarao link=topic=219396.msg2702965#msg2702965 date=1312301035]
cursors and types of cursors &D_@@ &D_@@ &D_@@ &D_@@
[/quote]

cursor ante....processing of each row...in a loop...


Posted

[quote author=meghana9 link=topic=219396.msg2702981#msg2702981 date=1312301344]
cursors ipudu use chetshunnara ? adhi ekuva use cheyaru... it slowers the performance of the database
[/quote]but oraclelo basicga cursors untayi. data will be retrieved using cursors only sSa_j@il

×
×
  • Create New...