1.

Why is normalization needed in a database?

Answer»

The term "normalization" refers to the process of analyzing relation schemas BASED on their functional dependencies. Normalization is the TECHNIQUE of splitting up data into numerous TABLES to reduce redundancy.

The advantages of normalization are:

  • Standardization eliminates the copy information, allowing a smaller database to be maintained. As a result, the size of the database is reduced in general.
  • Better execution is assured, which is related to the previous point. As the size of information bases shrinks, the time it takes to process it becomes shorter and more CONSTRAINED, enhancing reaction time and speed.
  • Narrower tables may be possible as standardized tables are altered and feature fewer segments, allowing for more data items per page.
  • With fewer files per table, support assignments are completed faster (file modifies).


Discussion

No Comment Found

Related InterviewSolutions