Consider a relation with schema r(a, b, c, d, e) and fd’s ab → c, c → d, d → b, d → e
1. indicate all bcnf violations. do not forget to consider fd's that are not in the given set, but follow from them. only give violations that have a single attribute on the right side.
2. decompose the relation into a collection of relations in bcnf.
3. indicate 3nf violations.
4. decompose the relation into a collection of relations in 3nf.