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...
When using physical phenomena to encode information, name one potential solution if there are more than two alternatives.
a. There is no solution b. adopt them all as present c. adopt one as present and all the other alternatives as absent d. adopt them all as absent
A ________ is a category of data that is organized and named
A) list B) field C) record D) source
All of the following EXCEPT ________ turns a numbered or bulleted list off
A) pressing the Esc key B) pressing Enter two times C) clicking the Numbering or Bullets button D) pressing the Backspace key
Slides can be hidden using the ________ views
A) Slide Sorter or Normal B) Slide Show or Slide Sorter C) Slide Show and Normal D) Reading and Slide Show