Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 10

Consider the universal relation R = {A, B, C, D, E, F, G, H, I} and the set of functional dependencies F = { {A, B} - > {C}, {A} - > {D, E}, {B} - > {F}, {F} - > {G, H}, {D} - > {I, J} }. What is the key for R? Decompose R into 2NF, then 3NF relations.