What is Normalization in DBMS?

Posted on Updated on

Normalization is a formal process for determining which fields belong in which tables in a relational database. Normalization follows a set of rules worked out at the time relational databases were born. A normalized relational database provides several benefits:

  • Elimination of redundant data storage.
  • Close modeling of real world entities, processes, and their relationships.
  • Structuring of data so that the model is flexible.
  • Normalization ensures that you get the benefits relational databases offer. Time spent learning about normalization will begin paying for itself immediately.

Related posts:

  1. What are the advantages and disadvantages of online shopping?
  2. Write a short note on Social Networking.
  3. Short Note on GIMP
  4. Write a short note on Tags and Attributes in HTML.

Leave a Reply

Your email address will not be published. Required fields are marked *