You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
98-364 Exam QuestionsBrowse all questions from this exam
98-364 Exam - Question 4
Show AnswerHide Answer
Correct Answer: D
In a relational database, when we say that one attribute is functionally dependent on another, it means that for each value of the first attribute, there is exactly one corresponding value of the second attribute. In the given table, each ProductID has exactly one ProductCategory associated with it. Thus, the term that best describes this relationship is 'Functionally dependent'.
Discussion
2 commentsjrn1992
Jun 1, 2020In relational database theory, a functional dependency is a constraint between two sets of attributes in a relation from a database. In other words, functional dependency is a constraint that describes the relationship between attributes in a relation
elkreationZ
Jun 25, 2021D) Functionally dependent