Question

    A relation is in 2NF

    if:
    A It is in 1NF and has no multivalued attributes Correct Answer Incorrect Answer
    B It is in 1NF and every non-prime attribute is fully functionally dependent on the primary key Correct Answer Incorrect Answer
    C It has transitive dependencies Correct Answer Incorrect Answer
    D It has no repeating groups Correct Answer Incorrect Answer
    E It is in 3NF and has a candidate key Correct Answer Incorrect Answer

    Solution

    2NF eliminates partial dependencies by ensuring full functional dependence on the whole key.

    Practice Next
    More IT DBMS Questions
    ask-question