Why does a database table expressing all possible combinations of values of 2 attributes violate 4NF?
Sometimes a database table is supposed to contain every possible combination of two (independent) things. I know such a table is subject to deletion anomalies of the kind that 4NF is supposed to prevent, and so I assume such a table must violate Fourth Normal Form (4NF).
Why does a database table expressing all possible combinations of values of 2 attributes violate 4NF?
Sometimes a database table is supposed to contain every possible combination of two (independent) things. I know such a table is subject to deletion anomalies of the kind that 4NF is supposed to prevent, and so I assume such a table must violate Fourth Normal Form (4NF).