Page 208 - IT_V1.0_Class10
P. 208
Minimal Data Redundancy
Databases reduce data redundancy by storing information in a centralised
manner for avoiding duplication and saving storage space. For example, an
online store database maintains customer information such as addresses
and payment methods, ensuring each customer’s data is stored once and
updated as needed.
Data Consistency
Databases enforce data consistency rules to ensure that information is accurate and
up-to-date across all related records. For example, a university database ensures that
student records, including grades and course registrations, are consistent across all
administrative systems for preventing errors in academic documents.
Increases Efficiency
Databases streamline data management processes, reducing manual effort and
improving operational efficiency. For example, a healthcare database allows
medical professionals to access patient records quickly that leads to faster
diagnosis and treatment decisions.
Increases Accuracy
Databases improve data accuracy by reducing human error in data entry
and ensuring data validation rules are enforced. For example, a financial
institution uses a database to manage transactions, ensuring that each
financial record is accurate and complete for auditing and compliance
purposes.
Increases Validity
Databases maintain data validity by enforcing integrity constraints and validation
rules, ensuring that only valid data is entered into the database. For example,
an online reservation system verifies booking details against available seats in
real-time for ensuring that only valid reservations are confirmed.
Security
Databases offer robust security features to protect sensitive information from
unauthorised access and breaches. For example, a government database storing citizen
information uses encryption and access controls to safeguard personal data against
cyber threats and privacy breaches.
Features of Database
The main features of a database are as follows:
A database can contain multiple tables where each table stores a specific set of related information.
The information stored in a database table is specific to a particular topic that helps users to view all
related information in a single table.
206 Information Technology Play (Ver 1.0)-X

