All Questions

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

MCQ Question 1 of 10

Question 1: Normalization - 1NF Rule

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

Eliminate transitive dependencyRemove partial dependencyEnsure atomic values (no repeating groups)Each table has a foreign key

Question 2: Normalization - 2NF Condition

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

Partial dependencyTransitive dependencyCandidate key redundancyDuplicate rows

Question 3: Normalization - 3NF Requirement

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

It is in 2NF and has no repeating groupsIt is in 2NF and no transitive dependencies existIt has only one primary keyAll attributes are atomic

Question 4: Normalization - BCNF Condition

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

1NF2NF3NF4NF

Question 5: Normalization - 1NF Example

Which table violates 1NF?

Student(ID, Name, Age)Student(ID, Subjects: Math, Science)Orders(OrderID, CustomerID)Employee(ID, Salary)

Question 6: Normalization - 2NF Example

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

StudentName depends only on StudentID, not full keyCourseID is not uniqueDuplicate rows existStudentName is atomic

Question 7: Normalization - 3NF Example

Which of the following shows a transitive dependency?

StudentID → CourseIDStudentID → DepartmentID → DepartmentNameOrderID → CustomerIDEmployeeID → Salary

Question 8: Normalization - BCNF Violation

Which situation requires BCNF instead of 3NF?

Non-atomic values existCandidate keys overlap and dependencies existNo primary key definedTransitive dependencies exist

Question 9: Denormalization - Concept

What is the purpose of denormalization in databases?

Reduce redundancy completelyImprove query performance by allowing controlled redundancyRemove transitive dependenciesConvert schema to BCNF

Question 10: Normalization vs Denormalization

Which statement is true?

Normalization increases redundancyDenormalization always reduces performanceNormalization ensures data integrity, denormalization improves performanceBoth always eliminate redundancy