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
   203   204   205   206   207   208   209   210   211   212   213