INTERVIEW QUESTIONS DATABASE MYSQL DETAILS

Question: Explain about normalization?

Answer: Applying specific rules (normal forms) to the database is the primary process. These rules should be applied in the order specified starting with the first normal form. These rules should be adhered by every database they are
1) Each column should have only one value
2) Repeating columns of data cannot be done.

Applying specific rules (normal forms) to the database is the primary process. These rules should be applied in the order specified starting with the first normal form. These rules should be adhered by every database they are
1) Each column should have only one value
2) Repeating columns of data cannot be done. Source: CoolInterview.com

It is a process of analyzing the given relation schema based on their functional dependencies and primary key to minimize
1. the redundancy
2. the insertion , deletion , updation anomaly . Source: CoolInterview.com

It's a process of redunduncy of the duplicate columans.In this we have 5normal forms but last two are used in academics.
The first normal form(1NF) involves removal of redundant data from horizontal rows. we want to ensure that there is no duplicate data in the given row.and that every column stors least amonut of data.
In the 2NF deals with redunduncy of data in vertical columns. so to achieve second NF your tables must be in 1NF.
In the 3NF we are looking for the data in our tables that is not fully dependent on the primary key,but depedent on another value in the table.

Regards,
Jyotsna.Inampudi

Source: CoolInterview.com

normal form involves removal of redudant data from horiaontal rows.we want to ensure that there is no duplicate data in given row and every column saves least amount of data Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question