📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

  • google app store apple app store
  • ✖

      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
      ask-question