Explain the concept of a functional dependency. What will be ...

[melly21297]

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]

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

[melly21297]

TYSM

[Jsherida]

Excellent