COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEMS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In which dependency, a nonkey column is dependent on part of the primary key?
A
Partial dependency
B
Transitive dependency
C
Total (or) full dependency
D
None of the above
Explanation: 

Detailed explanation-1: -Partial Dependency occurs when a non-prime attribute is functionally dependent on part of a candidate key. The 2nd Normal Form (2NF) eliminates the Partial Dependency.

Detailed explanation-2: -A transitive dependency occurs when one non-prime attribute is dependent on another non-prime attribute.

There is 1 question to complete.