Although planned data redundancy increases the distribution of redundant data to a very meager degree, this type of redundancy most often involves few columns of relational tables and helps to enforce both entity and referential integrities.
This paper discusses planned data redundancy as it relates to the structure of database tables and the integrity of data contained in the tables. Due to their unique functions and for easy understanding, tables’ primary keys and foreign keys columns are used to demonstrate the implementation. First normal form (1NF), third normal form (3NF), fourth normal form (4NF), and the Redundant Data technique of denormalization process are the yardsticks used to illustrate how planned data redundancy is generated, in which keys’ columns it occurs, and its benefits to the resulting tables. Planned data redundancy is classified into two groups, namely, internal planned data redundancy and external planned data redundancy, and to understand their formation, normalization and normal forms as well as denormalization are discussed at the infancy level.
|Keywords:||Data Redundancy, Denormalization, Normal Forms, Normalization, Planned Redundancy, Relational Database, Data Tables|
Full Professor of Management Information Systems, Department of Computer Sciences and Mathematics, Florida Memorial University, Miami Gardens, Florida, USA
There are currently no reviews of this product.Write a Review