×

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

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

ڈیٹا بیس نارملائزیشن میں، کون سا عام شکل اس بات کو یقینی بناتا ہے کہ ہر نان پرائم وصف مکمل طور پر ہر امیدوار کلید پر منحصر ہے؟
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.