Question: what is data redundancy how can it be reduced in database?
Answer: Redundant data wastes valuable space and creates troubling database maintenance problems. To eliminate redundant data from your Microsoft Access database, you must take special care to organize the data in your data tables. Normalization is a method of organizing your data to prevent redundancy.