Normal Forms
1NF : A table is in 1NF if all the attributes in it are atomic. There should not be any multivalued attribute. For example Consider the following scenario EID Mobile No. 1 8438145610,9494949492 2 8484848484 3 3939393993,3434344343 In this case 1 and 3 have multiple values for Mobile No. attribute. We should eliminate them by create separate columns for each mobile number. If every attribute has only one value, then the table is in 1 NF. 2NF : A table is in 2 NF if the following conditions are met a) A table is already in 1NF and b) For all X->A there should not be a "Partial Dependency" What is Partial Dependency ? For all X->A => X is a proper subset of candidate keys and A i...