Normalization and Denormalization

Author Topic: Normalization and Denormalization  (Read 2117 times)

Offline SeoDezinTopic starter

  • Trade Count: (0)
  • Sr. Member
  • ****
  • Thank You 16
  • Posts: 284
  • 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 3
  • Posts: 797
  • 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.

Offline dark404

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 1
  • Posts: 180
  • Karma: 0
    • F1removals.co.uk
Re: Normalization and Denormalization
« Reply #3 on: 09-22-2022, 10:31:19 »
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.

 

Related Topics

  Subject / Started by Replies Last post
6 Replies
5832 Views
Last post 08-12-2022, 09:55:51
by dark404