Question

Functional dependencies that have a time associated with them during which they are valid are called as________

(a) Timed functional dependencies

(b) Clocked functional dependencies

(c) Temporal functional dependencies

(d) Modeled functional dependencies

The question was posed to me during a job interview.

The above asked question is from Normal Forms topic in portion Relational Database Design of RDBMS

Answer 1

Right answer is (c) Temporal functional dependencies

To explain: Functional dependencies that have a time associated with them during which they are valid are called as temporal functional dependencies. All snapshots of the relation should satisfy the functional dependency for it to be a temporal functional dependency.