Data Normalisation, Primary Key and Foreign Key
What is Data Normalization? Wikipedia defines data normalization as " T he process of restructuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity " Normalization is nothing but a process of identifying and arranging data which will help to avoid storing duplicate data and at the same time not missing any data that is needed for processing or analysis. Too difficult to understand by just reading the above statements. Lets understand the meaning and process of normalization by looking at some examples from various fields. Data Normalization process of a book Library: Every Library has a list of books and a list of its members who borrow a single book or multiple books at any given point of time or no book has been borrowed by the member from the library. Unfortunately, this library cannot afford to buy any library software for management. Cur...