Database design and normalization are fundamental to creating efficient and scalable databases. Good design ensures that data is stored logically and reduces redundancy. Normalization organizes data into tables and minimizes dependency issues by dividing larger tables into smaller, related ones. Concepts like primary keys, foreign keys, functional dependencies, and normal forms (1NF, 2NF, 3NF, BCNF) are vital. Preparing for these topics with multiple-choice questions (MCQs) enhances your knowledge and ensures confidence during interviews.
1.) What does ER stand for in ER Diagram?
2.) What is the key benefit of schema normalization in large databases?
3.) What does a foreign key represent in a database?
4.) What is the purpose of indexing in SQL?
5.) What is the first step in database normalization?
6.) Which normal form eliminates partial dependency?
7.) Which normal form eliminates transitive dependency?
8.) What does BCNF stand for?
9.) What is functional dependency in a database?
10.) What happens if a table is not normalized?