Question : Which statement is NOT true about First Normal Form?
Solution :
Correct Answer : It removes all redundancy
Description -
Question : A relation has attributes (Student_ID, Courses) where Courses contains multiple values per student. Which is the correct 1NF conversion?
Solution :
Correct Answer : Create separate rows for each course per student
Description -
Question : Which of the following transformations converts a relation into 1NF?
Solution :
Correct Answer : Splitting multi-valued attributes into separate rows
Description -
Question : Consider a table storing multiple phone numbers in a single column separated by commas. What violation does this represent?
Solution :
Correct Answer : Multi-valued attribute violation
Description -
Question : Which of the following best describes a relation in First Normal Form (1NF)?
Solution :
Correct Answer : Each attribute contains only atomic (indivisible) values
Description -
Question : A table has a single-attribute primary key. Which of the following is correct?
Solution :
Correct Answer : It is automatically in 2NF
Description -
Question : Which of the following statements is TRUE regarding 2NF?
Solution :
Correct Answer : It is applicable only when primary key is composite
Description -
Question : Consider a relation STUDENT_COURSE(StudentID, CourseID, StudentName, CourseName)
Primary Key: (StudentID, CourseID)
Which normalization step converts it to 2NF?
Solution :
Correct Answer : Separate attributes depending on part of key into new tables
Description -
Question : Which of the following conditions must be satisfied for a relation to be in Second Normal Form (2NF)?
Solution :
Correct Answer : It must be in 1NF and eliminate partial dependency
Description -
Question : A relation R(A, B, C, D) has a composite primary key (A, B). The following dependencies exist:
A → C
(A, B) → D
Which statement is correct?
Solution :
Correct Answer : Relation is in 1NF but not in 2NF
Description -
Question : Which of the following is the main objective of 3NF?
Solution :
Correct Answer : Remove transitive dependencies and improve data integrity
Description -
Question : Consider attributes: EMP_ID → EMP_ZIP → EMP_CITY.
Why does this violate 3NF?
Solution :
Correct Answer : EMP_CITY is transitively dependent on EMP_ID
Description -
Question : Which of the following best describes a transitive dependency?
Solution :
Correct Answer : A non-prime attribute depends on another non-prime attribute
Description -
Question : In a relation R, a functional dependency X → Y satisfies 3NF if:
Solution :
Correct Answer : X is a super key OR Y is a prime attribute
Description -
Question : Which of the following conditions must be satisfied for a relation to be in Third Normal Form (3NF)?
Solution :
Correct Answer : It must be in 2NF and have no transitive dependency
Description -
Question : What is the main purpose of converting a relation into BCNF?
Solution :
Correct Answer : To remove anomalies due to functional dependencies
Description -
Question : A relation has FD: A → B, B → C. If A is the candidate key, what is the highest normal form satisfied?
Solution :
Correct Answer : 3NF but not BCNF
Description -
Question : Which statement correctly describes BCNF compared to 3NF?
Solution :
Correct Answer : Every BCNF relation is in 3NF, but not vice versa
Description -
Question : Consider relation R(X, Y, Z) with FD = {XY → Z, Z → Y}. Which is correct?
Solution :
Correct Answer : R is in 3NF but not in BCNF
Description -
Question : Which condition must hold true for a relation to be in BCNF?
Solution :
Correct Answer : For every functional dependency X → Y, X must be a super key
Description -
Question : Which of the following is a direct benefit of converting a relation into 4NF?
Solution :
Correct Answer : Eliminates unnecessary data duplication
Description -
Question : A table is in 3NF but still shows redundancy due to independent attributes. What is the main reason it is not in 4NF?
Solution :
Correct Answer : Presence of multivalued dependency
Description -
Question : Which of the following best describes a multivalued dependency (MVD)?
Solution :
Correct Answer : One attribute determines multiple independent values of another
Description -
Question : A relation R(A, B, C) has multivalued dependencies:
A →→ B and A →→ C.
What is the correct decomposition to achieve 4NF?
Solution :
Correct Answer : (A, B) and (A, C)
Description -
Question : Which condition is necessary and sufficient for a relation to be in Fourth Normal Form (4NF)?
Solution :
Correct Answer : It must be in BCNF and have no non-trivial multivalued dependencies
Description -
Question : A relation R has a join dependency (R1, R2, R3) such that none of R1, R2, R3 is a superkey. What can be concluded?
Solution :
Correct Answer : R is not in 5NF
Description -
Question : Which of the following is TRUE regarding 5NF and 4NF?
Solution :
Correct Answer : Every 5NF relation is in 4NF
Description -
Question : Which statement about join dependency (JD) is correct?
Solution :
Correct Answer : It guarantees lossless decomposition when relations are joined back
Description -
Question : What is the primary purpose of 5NF decomposition?
Solution :
Correct Answer : Eliminate redundancy caused by join dependencies
Description -
Question : Which of the following conditions must be satisfied for a relation to be in Fifth Normal Form (5NF)?
Solution :
Correct Answer : It is in 4NF and has no non-trivial join dependency
Description -