Author Question: Explain the concept of a functional dependency. What will be an ideal ... (Read 47 times)

melly21297 · **on:** Jul 7, 2018

Explain the concept of a functional dependency.

What will be an ideal response?

Question 2

The recovery method where the database is restored using the saved data, and all transactions since the save are reapplied is called ________ recovery.

Fill in the blank(s) with correct word

Sierray · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

A functional dependency is a relationship that exists among the attributes of a relation, such that if the value of one attribute or group of attributes is known, the value of another attribute or group of attributes can be determined. In a functional dependency, the attribute(s) whose value determines the value of the other attribute is called the determinant. The other attribute, whose value is determined by the determinant, is said to be functionally dependent on the determinant.

Answer to Question 2

rollforward