COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Partial dependency
|
|
|
Transitive dependency
|
|
|
Total (or) full dependency
|
|
|
None of the above
|
Detailed explanation-1: -A partial functional dependency exists when a nonkey attribute is functionally dependent on part (but not all) of the primary key.
Detailed explanation-2: -Second Normal Form (2NF) A relation is in second normal form (2NF) if it satisfies the first normal form requirements, and if every non-key attribute is fully functionally dependent on the primary key. This means that each non-key attribute in a row must be dependent on the entire primary key, not simply part of it.
Detailed explanation-3: -What is Partial Dependency? Partial Dependency occurs when a non-prime attribute is functionally dependent on part of a candidate key.
Detailed explanation-4: -A transitive dependency occurs when one non-prime attribute is dependent on another non-prime attribute.