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?
|
|
Partial dependency
|
|
|
Transitive dependency
|
|
|
Total (or) full dependency
|
|
|
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.