4NF

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-H CD. c) R(A, B,C,D) with MVD AB C and FD B D. d) R(A,B,C,D,E) with MVD's A + B and AB C and FD's A D and AB E. do the following: i) Find all the 4NF violations. ii) Decompose the relations into a collection of relation schemas in 4NIF 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-H CD. c) R(A, B,C,D) with MVD AB C and FD B D. d) R(A,B,C,D,E) with MVD's A + B and AB C and FD's A D and AB E. do the following: i) Find all the 4NF violations. ii) Decompose the relations into a collection of relation schemas in 4NIF