Functional dependencies | Relation(s) |
---|---|
a1 -> a2 | A |
a1 -> a3 | A |
a1 -> a4 | A |
a3 -> a4 | A |
b1 -> b2 | B |
b1 -> b3 | B |
b1 -> b4 | B |
b1 -> b5 | B |
Another possible way to arrange a list of FDs:
A Table |
a1 -> a2 |
a1 -> a3 |
a1 -> a4 |
B Table |
b1 -> b2 |
b1 -> b3 |
b1 -> b4 |
b1 -> b5 |
Table B is/is not in 3NF because... Table B is/is not in BCNF because...