35.6k views
3 votes
Are all non-key attributes of composite key tables fully functionally dependent on the key?

1) True
2) False

1 Answer

5 votes

Final answer:

The statement that all non-key attributes of composite key tables are fully functionally dependent on the key is false; an attribute must be dependent on the entire key and not any subset to be considered fully functionally dependent.

Step-by-step explanation:

Are all non-key attributes of composite key tables fully functionally dependent on the key? The statement is false. Not all non-key attributes in composite key tables are fully functionally dependent on the key. Fully functionally dependent means that an attribute is functionally dependent on a composite key but not on any subset of that key. For an attribute to be fully functionally dependent on a composite key, it must be the case that the attribute cannot be determined by any subset of the key.

User Binwiederhier
by
7.8k points