A functional dependency is a relationship between or among:
A. tables.
B. rows.
C. relations.
D. attributes.
Answer: Option D
Solution (By Examveda Team)
Option1: A functional dependency is not a relationship between tables. Tables in a relational database store data in a structured format but do not have direct relationships with each other in terms of functional dependencies.Option2: A functional dependency is not a relationship between rows. Rows in a table represent individual records and do not have functional dependencies with each other.
Option3: A functional dependency is a relationship between relations. In the relational model, a relation is a table with rows and columns, and functional dependencies describe the relationships between attributes within a relation.
Option4: A functional dependency is a relationship between attributes. In the relational model, attributes are the columns in a table, and functional dependencies describe how the values of certain attributes determine the values of other attributes.
Conclusion: The correct option is Option4: attributes. Functional dependencies describe the relationships between attributes in a relation in the relational model.
Join The Discussion