MYSQL DATABASE INTERVIEW QUESTIONS

What is the Second Normal Form (2NF) in database normalization?

How do you ensure a table is in Second Normal Form (2NF)?

Why is it important for a table to be in Second Normal Form (2NF)?

Can you provide an example of a table that is in 1NF but not in 2NF, and explain how to convert it to 2NF?

What is a partial dependency, and why must it be removed to achieve 2NF?

How do composite primary keys affect normalization to 2NF?

Describe a scenario where a table is normalized to 2NF but still has anomalies that need addressing.

Explain how you would normalize a table with composite keys to 2NF, including the creation of new tables.

What challenges might you face when converting a table to 2NF, and how would you address them?

Discuss the importance of achieving 2NF in a database used for an e-commerce application and the potential impact of not doing so.