Database

For the following, look at 3NF violations and subsequent decomposition of the relations.

a. Indicate all of the 3NF violations, if none, state: i. R(A, B, C, D) with FDs B C and BD. ii. R(A, B, C, D) with FDs ABC, BC D, CD A, and AD B. iii. R(A, B, C, D, E) with FDs AB C and DE C, and B D. iv. R(A, B, C, D, E) with FDs AB C and CD, D B, and D E. b. Decompose the above relations into collections of relations that are in 3NF and project the FDs onto the new relations.