Using a database improves data integrity, provides concurrency control, and reduces data redundancy. Together, these benefits make stored data more accurate, consistent, secure, and efficient when multiple users or applications need access.
How the Benefits Work
A database management system (DBMS) centrally manages data and controls how it is stored, modified, and retrieved. This is more reliable than maintaining separate, unconnected files.
| Benefit | Mechanism and example |
|---|---|
| Data integrity | The DBMS uses validation rules, data types, primary keys, foreign keys, and other constraints to keep data accurate and consistent. For example, a primary key prevents two students from having the same student ID, while a foreign key can prevent a result from referring to a student who does not exist. |
| Concurrency control | The DBMS coordinates simultaneous access by multiple users. Transactions, locking, and transaction isolation help prevent conflicting updates, such as two staff members overwriting each other's changes to the same student record. |
| Reduced redundancy | Data is stored once and referenced where needed rather than duplicated across many files. For example, a student's contact details can be stored in a STUDENT table and linked to examination results using the student ID. |
Reducing redundancy also reduces the risk of an update anomaly. If the same address appears in five separate files, one copy might be changed while the other four remain outdated. A well-designed relational database stores the address once, so one update keeps all linked uses consistent.
A common misconception is that reduced redundancy means eliminating all repeated values. Some repetition is necessary, particularly when foreign keys link tables; the aim is to avoid unnecessary duplication of the same fact.
Exam Technique
For IB Computer Science topic A3.1, do more than list the three benefits. For an explain question, identify each benefit and show how a DBMS achieves it, using a brief database example. Distinguish integrity from security: integrity concerns the accuracy and consistency of data, whereas security concerns preventing unauthorized access.
