SQL question: 4th Normal Form:

Exercise 3.6.3: For each of the following relation schemas and dependencies a) R(A, B, C, D) with MVD's A and A C. b) R(A, B, C, D) with MVD's A-B and B -CD. c) R(A, B,C, D) d) R(A,B,C,D,E) with MVD's A-H B and AB C and FD's A D with MVD AB C and FD B D and AB E. do the following: i) Find all the 4NF violations. ii) Decompose the relations into a collection of relation schemas in 4NF