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.
You might also like to view...
Charles Babbage designed the first automatic calculator in 1834
Indicate whether the statement is true or false
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