New Enroll in our GIC Finance Online Course Here!

    Register

    Question

    Which of the following correctly describes the second

    normal form (2NF) in database normalization?
    A The table contains no duplicate rows. Correct Answer Incorrect Answer
    B The table has no partial dependency Correct Answer Incorrect Answer
    C Every determinant is a candidate key Correct Answer Incorrect Answer
    D The table is free from transitive dependency Correct Answer Incorrect Answer
    E All attributes depend on the primary key. Correct Answer Incorrect Answer

    Solution

    A table is in Second Normal Form (2NF) if it is in First Normal Form (1NF) and all non-key attributes are fully functionally dependent on the entire primary key, not just part of it. This eliminates partial dependencies, which occur when a non-key attribute depends on only a part of a composite primary key. Why Other Options Are Incorrect:

    • The table contains no duplicate rows: This is a general requirement for any relational database, not specific to 2NF.
    • Every determinant is a candidate key: This describes Boyce-Codd Normal Form (BCNF) , a stricter form of 3NF.
    • The table is free from transitive dependency: This is achieved in Third Normal Form (3NF) , not 2NF.
    • All attributes depend on the primary key: This defines 1NF but does not address partial dependencies, a key focus of 2NF.

    Practice Next