Q10
A functional dependency is a relationship between or among:
A.
tables.
B.
rows.
C.
relations.
D.
attributes.
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
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.