Database Normalization Techniques

In database normalization, which normal form ensures that every non-prime attribute is fully functionally dependent on every candidate key?

ڈیٹا بیس نارملائزیشن میں، کون سا عام شکل اس بات کو یقینی بناتا ہے کہ ہر نان پرائم وصف مکمل طور پر ہر امیدوار کلید پر منحصر ہے؟
Answer: 2NF
Explanation
  • Second Normal Form (2NF) ensures that every non-prime attribute is fully functionally dependent on every candidate key.
  • It eliminates partial dependencies, where non-prime attributes depend only on part of a candidate key.
  • This question appeared in Past Papers (1 times)
    This question appeared in Subjects (1 times)

    Install this app on your device for quick access right from your home screen.