MYSQL DATABASE INTERVIEW QUESTIONS

What is normalization in the context of databases?

What is the First Normal Form (1NF) in database normalization?

How do you ensure a table is in First Normal Form (1NF)?

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

Why is it important for a table to be in First Normal Form?

What are atomic values and why are they important in 1NF?

How does 1NF relate to the concept of primary keys?

Describe a scenario where a table violates 1NF and the potential issues it can cause.

How would you handle composite attributes to ensure a table is in 1NF?

Explain the process of normalizing a database to First Normal Form with an example involving a student enrollment system.