| 1. |
What Do You Understand By Database Normalization? |
|
Answer» Normalization is very ESSENTIAL part of relational model. It consists of set of procedures that eliminates the domains that are non-atomic and redundancy of data that prevents data manipulation and loss of data INTEGRITY. Normal forms are the common form of normalization. It helps in reducing redundancy to increase the information overall. It has some DISADVANTAGES as it increases complexity and have some OVERHEAD of processing. Normalization is very essential part of relational model. It consists of set of procedures that eliminates the domains that are non-atomic and redundancy of data that prevents data manipulation and loss of data integrity. Normal forms are the common form of normalization. It helps in reducing redundancy to increase the information overall. It has some disadvantages as it increases complexity and have some overhead of processing. |
|