Discussion about normal forms in SQL

[Virat Kohli]

[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]

[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]

[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]

Example on 3NF

Table: Employee (2NF)
emp_no  name  dept_no  dept_name  skills
1  Kevin Jacobs  201  R&D  C, Perl, Java
2  Barbara Jones  224  IT  Linux, Mac
3  Jake Rivera  201  R&D  DB2, Oracle, Java

Dept_no and dept_name are functionally dependent on emp_no however, department can be considered a separate entity.

AFTER 3NF

Employee (3NF)
emp_no name dept_no
1 Kevin Jacobs 201
2 Barbara Jones 224
3 Jake Rivera 201

Department (3NF)

dept_no dept_name
201 R&D
224 IT

[jamesbond]

[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]

[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]

[quote author=galigannarao link=topic=219396.msg2702848#msg2702848 date=1312299943]
Table : Employee (1NF)
emp_no name dept_no dept_name skills
1 Kevin Jacobs 201 R&D C
1 Kevin Jacobs 201 R&D Perl
1 Kevin Jacobs 201 R&D Java
2 Barbara Jones 224 IT Linux
2 Barbara Jones 224 IT Mac
3 Jake Rivera 201 R&D DB2
3 Jake Rivera 201 R&D Oracle
3 Jake Rivera 201 R&D Java


Name, 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 skills
1 Kevin Jacobs 201 R&D C, Perl, Java
2 Barbara Jones 224 IT Linux, Mac
3 Jake Rivera 201 R&D DB2, Oracle, Java

Table: Skills (2NF)
emp_no skills
1 C
1 Perl
1 Java
2 Linux
2 Mac
3 DB2
3 Oracle
3 Java
[/quote]

thankyou thankyou

[manoghna]

[quote author=Jeedeelu link=topic=219396.msg2702828#msg2702828 date=1312299763]
naku 3NF example kavali........ardam kala..... cry@fl cry@fl cry@fl

2NF 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]

[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]

[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]

[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]

Next tofic denimeedha..... sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y

[galigannarao]

[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]

[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]

[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 :(