Question

    In database management systems (DBMS), which normalization form removes partial dependency?

    A First Normal Form (1NF) Correct Answer Incorrect Answer
    B Second Normal Form (2NF) Correct Answer Incorrect Answer
    C Third Normal Form (3NF) Correct Answer Incorrect Answer
    D Boyce-Codd Normal Form (BCNF) Correct Answer Incorrect Answer
    E Fourth Normal Form (4NF) Correct Answer Incorrect Answer

    Solution

    Second Normal Form (2NF) removes partial dependency, which occurs when a non-prime attribute is functionally dependent on part of a candidate key. A table is in 2NF if it is in 1NF and all non-key attributes are fully dependent on the primary key. Why Other Options are Wrong: a) 1NF deals with atomicity, ensuring that each column contains only indivisible values. c) 3NF removes transitive dependency, not partial dependency. d) BCNF is a stronger version of 3NF but does not specifically address partial dependency. e) 4NF deals with multi-valued dependencies.

    Practice Next