What does a functional dependency represent in the context of relational…
2025
What does a functional dependency represent in the context of relational databases?
- A.
A rule stating every table must include a primary key
- B.
A method for combining multiple relations into one
- C.
A technique used to transform an ER model into relational tables
- D.
A situation where one attribute uniquely determines another
Attempted by 187 students.
Show answer & explanation
Correct answer: D
In relational databases, a functional dependency describes a relationship between attributes where one attribute uniquely determines another attribute.
If attribute A functionally determines attribute B, written as:
A → B
it means that for each value of A, there is exactly one corresponding value of B.
Functional dependencies are important in database normalization and help reduce redundancy and maintain data consistency.