Normalization and Denormalization

Author Topic: Normalization and Denormalization  (Read 1728 times)

Offline SeoDezinTopic starter

  • Trade Count: (0)
  • Sr. Member
  • ****
  • Thank You 15
  • Posts: 282
  • Karma: 1
  • Gender: Male
    • http://cognitive46.wordpress.com/
Normalization and Denormalization
« on: 09-24-2020, 09:23:17 »
There are two terms used in database designing are normalization and de-normalization. Any one who can guide me the concept of both terms and when they are applied ?


Offline Lishmalinyjames

  • Trade Count: (0)
  • Hero Member
  • *****
  • Thank You 2
  • Posts: 800
  • Karma: 0
    • Oneplus Service Center in Chennai
Re: Normalization and Denormalization
« Reply #1 on: 03-29-2021, 04:25:17 »
Normalization is used to remove redundant data from the database and to store non-redundant and consistent data into it.  On another hand during Denormalization data is integrated into the same database and hence the number of tables to store that data increases in number.

Offline saravanan28

  • Trade Count: (0)
  • Sr. Member
  • ****
  • Thank You 2
  • Posts: 428
  • Karma: 0
Re: Normalization and Denormalization
« Reply #2 on: 04-12-2021, 05:41:22 »
Normalization is the technique of dividing the data into multiple tables to reduce data redundancy and inconsistency and to achieve data integrity. ... Redundant data is eliminated when normalization is performed whereas denormalization increases the redundant data. Normalization increases the number of tables and joins.

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
5476 Views
Last post 04-12-2021, 05:45:24
by saravanan28