Multivalued Dependency (MVD)
Sometimes, Functional Dependency are too simple and cannot capture all of the information.
Multivalued dependency occurs when two attributes in a table are independent of each other but both depend on a third attribute.
- Is the intuition that you end up with too many entries on the database? because it’s like a cross product join? https://www.youtube.com/watch?v=A6VGW1_1UHA&ab_channel=StanfordDbclass
There are inference axioms, similar to Armstrong’s Axioms