This blog moved to medium->https://medium.com/@cocoamaemae

Tuesday, February 6, 2018

Regarding normalization

What's normalization?
Divide RDB tables to satisfy functional dependencies.

Why normalization is necessary?
Merits

  • Possible to avoid the inconsistency when updating tables
  • To understand meanings of respective tables easier

Demerits

  • Increase JOIN and reduce SQL performance since the number of tables increase

Which normalization should be done?
Basically, it should always be done untill third normalization.




-
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Front End Development Tools

TaskRunner Tool executing multiple tasks by only one execution. Tasks are like CSS preprocessor, Transpire, Module Bundler, etc... e.g. ...

  • MySQL, MariaDB partitioning
    What is partitioning? The structure which divides one table data to multiple data. When not using partitioning, one table data is aggrega...
  • Best practice when merging multiple git branches
    It is general to create multiple branches and manage them parallel when we do the development by using git. Multiple branches should be mer...
  • Regarding URL encode
    What's URL encode? URL can be sent only ASCII characters over internet. When doing http request with query parameters, query parameter...