Question

On your part time job at a gym, you notice that there are a lot of issues with member’s data. The number one pain area is duplicate and often triplicate records for same member. The owners see no issue with this and are reluctant to ‘cleanse’ the data. Advise them on what could be the consequence of not doing so.

Answer 1

solution:

given data:

On your part time job at a gym:

As mentioned in the question that the pain area has the duplicates and often triplets records for the same member, generally such type of problems are referred as data redundancy which means having multiple copies of same data in the database, it arises when the database is not normalized, if we not notice it then it originates the following problems:-

1. Updation anomaly, in which if we update any record then we have to update all the copies of that record.
2. Deletion anomaly, in which if we want to delete the record then we have to delete all the copies of that record.
3. Accessing time gets increased as the total number of records gets increased hence the size of database gets also increased therefore searching for any record will increase the accessing time.
4. The memory space to store the database/records will also increase which is not good.

In order to avoid all these problem, we should avoid the data redundancy and it can be only achieved by making by the database normalized.

please give me thumb up