Normalization

Normalization: The objective of relational database is to generate a set of relations that allows the user to store information without unnecessary redundancy where permits to retrieve information easily. The right approach is to design schemes that are in appropriate normal form. The basic concept of normalization is that, same data should not be stored in multiple places or we can say through normalization conceptual schema (logical data structures) transformed in computer representable form. The normalization process helps to attain good database design.