What are the main characteristics of functional dependencies that are used when normalizing a relation?

What will be an ideal response?

In summary, the functional dependencies that we use in normalization have the following
characteristics:
? There is a one-to-one relationship between the attribute(s) on the left-hand side
(determinant) and those on the right-hand side of a functional dependency. (Note that the
relationship in the opposite direction; that is between the right to the left-hand side
attributes can be a one-to-one relationship or one-to-many relationship).
? Holds for all time.
? The determinant has the minimal number of attributes necessary to maintain the
dependency with the attribute(s) on the right hand-side. In other words, there must be a
full functional dependency between the attribute(s) on the left and right hand-side of the
dependency.

Computer Science & Information Technology

You might also like to view...

Charles Babbage designed the first automatic calculator in 1834

Indicate whether the statement is true or false

Computer Science & Information Technology

Legacy tools include which of these form fields?

A) check box B) option button C) drop-down box D) check box and drop-down box

Computer Science & Information Technology