Normalization – 1NF, 2NF, 3NF, BCNF, and denormalization.

    Question 1: Normalization - 1NF Rule

    What is the main requirement of First Normal Form (1NF)?

    Question 2: Normalization - 2NF Condition

    Which of the following must be eliminated to achieve Second Normal Form (2NF)?

    Question 3: Normalization - 3NF Requirement

    A table is in Third Normal Form (3NF) if:

    Question 4: Normalization - BCNF Condition

    Boyce-Codd Normal Form (BCNF) is a stricter version of which normal form?

    Question 5: Normalization - 1NF Example

    Which table violates 1NF?

    Question 6: Normalization - 2NF Example

    In table Enrollment(StudentID, CourseID, StudentName), why is it not in 2NF?

    Question 7: Normalization - 3NF Example

    Which of the following shows a transitive dependency?

    Question 8: Normalization - BCNF Violation

    Which situation requires BCNF instead of 3NF?

    Question 9: Denormalization - Concept

    What is the purpose of denormalization in databases?

    Question 10: Normalization vs Denormalization

    Which statement is true?