FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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.

Detailed explanation-2: -A partial functional dependency exists when a nonkey attribute is functionally dependent on part (but not all) of the primary key.

Detailed explanation-3: -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-4: -A transitive dependency occurs when one non-prime attribute is dependent on another non-prime attribute.

Detailed explanation-5: -Transitive dependency occurs when some non-key attribute determines some other attribute. On the other hand, partial dependency occurs when one primary key determines some other attribute/attributes.

There is 1 question to complete.