Explain 1st, 2nd, 3rd normalization form of data base

Question Posted / akshay

3 Answers
23171 Views
KH, Thermotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain 1st, 2nd, 3rd normalization form of data base..

Answer / padma

1st normal form: first identify the repeating group of
fields n group them into separate table
2nd normal: it should be in 1st normal form and check all
fields are dependent on primary key
3nd normal form: it should be in 2nd normal form and check
all the fields r independent of any other non-key attribute
ie removes the fields that dependent on non-key

1st normal: first identify repeating fields and group them
another table
2nd normal: it should be in 1st normal form and identify
that all fields all dependent on primary key.
3nd normal: it should be in 2nd normal form and check all
fields all indpendent of other non-key attribute

Is This Answer Correct ?

49 Yes

5 No

Explain 1st, 2nd, 3rd normalization form of data base..

Answer / misam ami

1st normal: A relvar is in 1NF if and only if,in every every legal value of that relavar,every tuple contains exactly one value for each attribute.
3rd normal: A relvar is in 3NF if and only if for all time,each tuple consist of a primary key value that identifies some entity,together with a set of zero or more mutually independent attribute values that describes values that describe that entity in some way.

Is This Answer Correct ?

5 Yes

3 No

Explain 1st, 2nd, 3rd normalization form of data base..

Answer / ramprasad.s

HI

First Normalisation is "Primary Key"

Second Normalisation is " Composite Key"

bye
sun_ramprasad@yahoo.com

Is This Answer Correct ?

8 Yes

36 No

Post New Answer