What are the conditions to achieve the normalization?
There are few conditions to achieve the normalization: * There should be a unique row identifier. * A table should store only data for a single type of entity. For e.g. details for book’s publisher and book’s author should be saved under different table. * A table should avoid columns which can be null-able. * A table should avoid duplication of data and columns.