A, B, C, E, F are atomic attributes.
F = {? A ? B;
? B ? C;
? A, B ? E;
? A, E ? F;
? A, F ? E
}
1) Explain when a fd f ? F is redundant?
2) Explain how to remove a fd in general.
3) Proof that fd ? A, F ? E ist redundant.
4) Apply the approach-by-synthesis to design a 3NF relational schema.