Trusted by millions of Kenyans
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Explain three advantages of a centralized database.

Explain three advantages of a centralized database.

Answers


Kavungya
Data Integrity - The single greatest benefit of centralizing an assn’s data management is data
integrity. One of the cardinal rules of database design is that no redundancy is allowed. That is,
no piece of data should ever be repeated within the database. When an organization is operating
multiple databases for the same group of people (for example, a membership database with a
separate meeting registration database), they are by definition breaking this rule.And this leads to
major data integrity issues. A centralized database means that each member has one primary
record, with primary contact information. Thus when there is a change required (like a new
phone number or email address), there is only one place to look to make these changes.

Valuable broad marketing info/history - With all the information centralized, it is much easier
to develop reports that show the broad range of activities that your members are engaged in.
With multiple databases, records need to be matched, de-duping needs to occur, and the
opportunity for duplicate records is greatly increased.

Ease of training (it’s the same system for everything) - Another benefit of a centralized
system is that the learning curve for users is greatly reduced. If all processes (membership,
meetings, products, etc.) are in the same database, then users need only learn one system, not
multiple systems.

Support - With a centralize system, support is focused on one product. With many databases,
even if they are built on the same platform, separate support is required for each.
Kavungya answered the question on May 14, 2019 at 06:47

Answer Attachments

Exams With Marking Schemes

Related Questions