Normalization is used to reduce the redundancy and duplicity.
definition: Normalization is a simple scientific method of breaking down complex table structures into simple table structures by using certain rules.
Some rules that should be followed to achieve a good database design are:
- Each table should have an identifier.
- Each table should store data for a single type of entity.
- Columns that accept NULLs should be avoided.
- The repetition of values or columns should be avoided.
definition: Normalization is a simple scientific method of breaking down complex table structures into simple table structures by using certain rules.
Some rules that should be followed to achieve a good database design are:
- Each table should have an identifier.
- Each table should store data for a single type of entity.
- Columns that accept NULLs should be avoided.
- The repetition of values or columns should be avoided.
No comments:
Post a Comment