72.0k views
3 votes
what exists in a table when a non-key attribute is functionally dependent on another non-key attribute.

1 Answer

5 votes

Final answer:

A non-key attribute is functionally dependent on another non-key attribute in a table when one attribute can be determined by the value of another attribute.

Step-by-step explanation:

In a table, when a non-key attribute is functionally dependent on another non-key attribute, it means that one attribute can be determined by the value of another attribute in the table.

For example, let's consider a table of students where the student's grade is functionally dependent on their age. If we know the age of a student, we can determine their grade. In this case, age is the determining attribute and grade is the determined attribute.

This type of relationship is known as functional dependency and is a key concept in database management.

User Charese
by
7.5k points