Examveda

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.

This Question Belongs to Database >> The Relational Model And Normalization

Join The Discussion

Related Questions on The Relational Model and Normalization