1
Q
Functional Dependencies
A
integrity constraints that can be used to identify schemas with such problems and to suggest refinements
2
Q
decomposition
A
splitting a table into multiple smaller tables
R (A, B, C, D) -> S(A, B) and T (B, C, D)
3
Q
lossless property
A
nonadditive join property
information contained in the original relation is preserved.
nothing added or removed
MUST MAINTAIN ALWAYS
4
Q
dependency preservation property
A
every functional dependency (FDs) in the original relation is present in one of the decomposed relations
can sometimes break this
5
Q
determinants
A
RHS {A, B, C}
6
Q
dependent
A
-> D
7
Q
FD shortcut
A
If not present on RHS has to be in key
COMP 3380
flashcards
Decks in class (7)
# Cards
