Virat Kohli Posted August 2, 2011 Report Posted August 2, 2011 [quote author=jamesbond link=topic=219396.msg2702861#msg2702861 date=1312300030]10gay bhe ^G#W[/quote]evarini 10gali sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y
jamesbond Posted August 2, 2011 Report Posted August 2, 2011 [quote author=charygaru link=topic=219396.msg2702847#msg2702847 date=1312299930]magaaaaa [img]http://www.gifsoup.com/view1/2119144/raga-o.gif[/img][/quote][quote author=ronitreddy link=topic=219396.msg2702851#msg2702851 date=1312299960]Hegidiya H&*() H&*()[/quote][quote author=charygaru link=topic=219396.msg2702858#msg2702858 date=1312300007]chennagid iya sCo_^Y sCo_^Y sCo_^Y sCo_^Y [/quote]abba..... maa batch inta mandi unnara....Ellarigu Kannada Gothaitra.... ella araama .. Oota aitha H&T@
jamesbond Posted August 2, 2011 Report Posted August 2, 2011 [quote author=charygaru link=topic=219396.msg2702847#msg2702847 date=1312299930]magaaaaa [img]http://www.gifsoup.com/view1/2119144/raga-o.gif[/img][/quote][quote author=ronitreddy link=topic=219396.msg2702851#msg2702851 date=1312299960]Hegidiya H&*() H&*()[/quote][quote author=charygaru link=topic=219396.msg2702858#msg2702858 date=1312300007]chennagid iya sCo_^Y sCo_^Y sCo_^Y sCo_^Y [/quote]abba..... maa batch inta mandi unnara....Ellarigu Kannada Gothaitra.... ella araama .. Oota aitha H&T@
galigannarao Posted August 2, 2011 Author Report Posted August 2, 2011 Example on 3NFTable: Employee (2NF)emp_no name dept_no dept_name skills1 Kevin Jacobs 201 R&D C, Perl, Java2 Barbara Jones 224 IT Linux, Mac3 Jake Rivera 201 R&D DB2, Oracle, JavaDept_no and dept_name are functionally dependent on emp_no however, department can be considered a separate entity.AFTER 3NFEmployee (3NF)emp_no name dept_no1 Kevin Jacobs 2012 Barbara Jones 2243 Jake Rivera 201Department (3NF)dept_no dept_name201 R&D224 IT
jamesbond Posted August 2, 2011 Report Posted August 2, 2011 [quote author=Jeedeelu link=topic=219396.msg2702845#msg2702845 date=1312299919]kani me analystlu requirements for a prj ela develop chestaru ba....... sCo_^Y sCo_^Y sCo_^Y[/quote]Depends on the task..... all about Listening to what the other person has to say..... The more you listen the better you can capture Ask Questions..... Avi enta foolish ga unna parla... try to capture every minute details H&*()
jamesbond Posted August 2, 2011 Report Posted August 2, 2011 [quote author=Virat Kohli link=topic=219396.msg2702873#msg2702873 date=1312300116]evarini 10gali sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y[/quote]mee aapees lo evarinaina Nalla danni CITI_c$y CITI_c$y
ronitreddy Posted August 2, 2011 Report Posted August 2, 2011 [quote author=galigannarao link=topic=219396.msg2702848#msg2702848 date=1312299943]Table : Employee (1NF)emp_no name dept_no dept_name skills1 Kevin Jacobs 201 R&D C1 Kevin Jacobs 201 R&D Perl1 Kevin Jacobs 201 R&D Java2 Barbara Jones 224 IT Linux2 Barbara Jones 224 IT Mac3 Jake Rivera 201 R&D DB23 Jake Rivera 201 R&D Oracle3 Jake Rivera 201 R&D JavaName, dept_no, and dept_name are functionally dependent on emp_no. (emp_no -> name, dept_no, dept_name)Skills is not functionally dependent on emp_no since it is not unique to each emp_no.Table: Employee (2NF)emp_no name dept_no dept_name skills1 Kevin Jacobs 201 R&D C, Perl, Java2 Barbara Jones 224 IT Linux, Mac3 Jake Rivera 201 R&D DB2, Oracle, JavaTable: Skills (2NF)emp_no skills1 C1 Perl1 Java2 Linux2 Mac3 DB23 Oracle3 Java[/quote] thankyou thankyou
manoghna Posted August 2, 2011 Report Posted August 2, 2011 [quote author=Jeedeelu link=topic=219396.msg2702828#msg2702828 date=1312299763]naku 3NF example kavali........ardam kala..... cry@fl cry@fl cry@fl2NF and 3NF mostly same ga vunnayi....[/quote]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
Virat Kohli Posted August 2, 2011 Report Posted August 2, 2011 [quote author=jamesbond link=topic=219396.msg2702893#msg2702893 date=1312300299]mee aapees lo evarinaina Nalla danni CITI_c$y CITI_c$y[/quote]oppukuntundhi antava H&T@ H&T@ H&T@ H&T@ H&T@ H&T@
Ranga_The_Donga Posted August 2, 2011 Report Posted August 2, 2011 [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: [size=14pt][b]2nd normal ni inka separate cheyali more tables ga ,and primary,foriegn key relationship leni tables ni remove cheyali[/b][/size][/quote]got it.... S%Hi S%Hi
Virat Kohli Posted August 2, 2011 Report Posted August 2, 2011 [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]meghana you rock you rock you rock you rock anthe simple ga keka cheptunnav........ na matti burra ke ardam indhi ante inka nuvvu keka cheppinatle Ammugif Ammugif Ammugif Ammugif Ammugif thankyou thankyou thankyou thankyou
Ranga_The_Donga Posted August 2, 2011 Report Posted August 2, 2011 Next tofic denimeedha..... sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y
galigannarao Posted August 2, 2011 Author Report Posted August 2, 2011 [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 chala clearga undi info
jamesbond Posted August 2, 2011 Report Posted August 2, 2011 [quote author=Virat Kohli link=topic=219396.msg2702909#msg2702909 date=1312300437]oppukuntundhi antava H&T@ H&T@ H&T@ H&T@ H&T@ H&T@[/quote] Ammugif Ammugif
charygaru Posted August 2, 2011 Report Posted August 2, 2011 [quote author=jamesbond link=topic=219396.msg2702878#msg2702878 date=1312300169]abba..... maa batch inta mandi unnara....Ellarigu Kannada Gothaitra.... ella araama .. Oota aitha H&T@[/quote]ardham aythadi kaani matladalenu annam thinatam endi ra bondu down with fever and headache office kuda pole :(
Recommended Posts