Database
A functional dependency is a relationship between :attributes.
Cardinality is always a relationship to another thing.
Max Cardinality(Cardinality) Always 1 or Many. Class A has a relationship to Package B with cardinality of one, that means at most there can be one occurance of this class in the package. The opposite could be a Package has a Max Cardnality of N, which would mean there can be N number of classes
Min Cardinality(Optionality) Simply means "required." Its always 0 or 1. 0 would mean 0 or more, 1 ore more
In simple word, for both the cases (FAN & CHASM) it will produce more line(result sets) than actual. How to identify
FAN -> 1-N-N (means table relation from one -> many -> many)
CHASM -> N-1-N (means one row table to two or more table many relation).
LOOP -> join all tables and when make loop like circle (In this case we will lose some rows absolutely)
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment