Explain 1st, 2nd, 3rd normalization form of data base
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is the diff between Oracle and SQL Server
What are the varoius components of physical database structure of oracle database?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are the composite date types in oracle?
How to define a variable to match a table column data type?
What is an oracle user account?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
How to define an oracle sub procedure?
what is primary key and foreign key when and where have to use
What is a Synonym ?
How to revoke create session privilege from a user in oracle?
How to save query output to a local file?