Database Schema Design
Interview Questions
- What is normalization?
- Explain 1NF, 2NF, and 3NF.
- When would you denormalize a database?
- Primary key vs unique key?
- What is a foreign key?
- What are database constraints?
- How would you design a one-to-many relationship?
- How would you design a many-to-many relationship?
- How do you decide which columns should be indexed?
- What does "schema optimization" actually mean?
Next TopicTransaction Basics