Explain Normalization concept?
Answers were Sorted based on User's Feedback
Answer / prasadhari_m@yahoo.com
Noramalization is process of desinnig the datamodel to
effentionley store the data in a database. to reduce the
redundancey.
1st normal form : Elimanate repating groups in individual
tables
Create separate table for ecah set of related data
Identify each set of related data with a primary key.
2nd normal form : Create separate tables for sets of values
that apply to multiply records
->relate these tables with a forgien key
3rd normal form : Elimanate fields that do not depend on
the key
Is This Answer Correct ? | 29 Yes | 2 No |
Answer / neha keshri
The usual approach in normalization in database
applications is to ensure that the data is divided into two
or more tables, such that when the data in one of them is
updated, it does not lead to anamolies of data.
Is This Answer Correct ? | 5 Yes | 1 No |
How can you see all indexes defined for a table?
How to convert dates to character strings?
What are date and time data types in mysql?
Why does mysql have so many connections?
How do I install the latest mysql on ubuntu?
What is action query?
Why use mysql procedures?
What is the full form of mysql?
Why is mysql used?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
What is back end and front end?
I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks