Discussion about normal forms in SQL

[galigannarao]

lets discuss about normal forms.

google definition ikkada paddayi ante plagiarism kinda pottalo podusta. kavali ante def akkada chusi ikkada meeku em aramyindo cheppandi.

please dont spam wanna make this thread useful for some people.

my first question -

oka databaseni enni normal forms varaku finetune chestaru in realtime S%Hi

[ronitreddy]

naku pedda idea ledu gaani..3nf ki chestharemo ? sCo_^Y sCo_^Y

[galigannarao]

[quote author=ronitreddy link=topic=219396.msg2702594#msg2702594 date=1312297691]
naku pedda idea ledu gaani..3nf ki chestharemo ? sCo_^Y sCo_^Y
[/quote] @gr33d

define first normal form &D_@@ &D_@@ &D_@@ &D_@@

[Antaraatma]

actual ga 5 nfs untayemo kada..  sCo_^Y sCo_^Y but in practise we implement only 3..  sCo_^Y sCo_^Y

[Ranga_The_Donga]

[quote author=galigannarao link=topic=219396.msg2702598#msg2702598 date=1312297732]
@gr33d

define first normal form &D_@@ &D_@@ &D_@@ &D_@@
[/quote]

no duplicates in a table..... sCo_^Y sCo_^Y sCo_^Y

[The QUEEN]

*=: *=: *=:

[ladysfinger]

Insert, delete.and update..  sCo_^Y

[quote author=galigannarao link=topic=219396.msg2702598#msg2702598 date=1312297732]
@gr33d

define first normal form &D_@@ &D_@@ &D_@@ &D_@@
[/quote]

[galigannarao]

[quote author=Luv Guru link=topic=219396.msg2702608#msg2702608 date=1312297931]
Insert, delete.. rende gurthunnai baa
[/quote]ayte ee tadu followka ardamvutundi neeke

[ronitreddy]

[quote author=galigannarao link=topic=219396.msg2702598#msg2702598 date=1312297732]
@gr33d

define first normal form &D_@@ &D_@@ &D_@@ &D_@@
[/quote]

well, basic ga normalization chesedi 1nf antaru ani telsu which meets certain specified criteria.. sCo_^Y sCo_^Y

[galigannarao]

[quote author=Jeedeelu link=topic=219396.msg2702604#msg2702604 date=1312297880]
no duplicates in a table..... sCo_^Y sCo_^Y sCo_^Y
[/quote]antena  sCo_^Y sCo_^Y

[galigannarao]

[quote author=ronitreddy link=topic=219396.msg2702612#msg2702612 date=1312297978]
well, basic ga normalization chesedi 1nf antaru ani telsu which meets certain specified criteria.. sCo_^Y sCo_^Y
[/quote]what was that criteria H&*()

[Ranga_The_Donga]

[quote author=galigannarao link=topic=219396.msg2702614#msg2702614 date=1312298002]
antena  sCo_^Y sCo_^Y
[/quote]

First Normal Form (1NF) sets the very basic rules for an organized database:

Eliminate duplicative columns from the same table.
Create separate tables for each group of related data

very basic nd 1st form kadha...alane vuntadhi anukunta....

[ronitreddy]

[quote author=Jeedeelu link=topic=219396.msg2702625#msg2702625 date=1312298132]
First Normal Form (1NF) sets the very basic rules for an organized database:

Eliminate duplicative columns from the same table.
Create separate tables for each group of related data and identify each row with a unique column (the primary key).
[/quote][quote author=Jeedeelu link=topic=219396.msg2702625#msg2702625 date=1312298132]
First Normal Form (1NF) sets the very basic rules for an organized database:

Eliminate duplicative columns from the same table.
Create separate tables for each group of related data and identify each row with a unique column (the primary key).
[/quote]

ave anukuntaa

[galigannarao]

[quote author=Jeedeelu link=topic=219396.msg2702625#msg2702625 date=1312298132]
First Normal Form (1NF) sets the very basic rules for an organized database:

Eliminate duplicative columns from the same table.
Create separate tables for each group of related data

very basic nd 1st form kadha...alane vuntadhi anukunta....
[/quote] @gr33d

now define second normal form with a scenario

[nenuinthe]

me dantlo edi follow avutaru bayya