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.
Related Questions on The Relational Model and Normalization
A. A → B.
B. A → C.
C. A → (B,C).
D. (B,C) → A.
A. normal forms.
B. referential integrity constraints.
C. functional dependencies.
D. None of the above is correct.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
A. second normal form.
B. third normal form.
C. fourth normal form.
D. domain/key normal form.

Join The Discussion