Page 84 - iPrime_V2.2_class7
P. 84

7                       Database and DBMS—




                                                               An Introduction











                        Chapter Profile

                           Concept of a Database             Advantages of a Database System
                           Types of Databases                Terms Related to a Database
                           Access 2016                       Components of Access 2016
                           Creating a Database               Data types in Access 2016
                           Types of views in Access          Naming Conventions for Writing a Field Name in Access
                           Creating a Table                  Opening an existing Database
                           Exiting Access 2016




                  Earlier, a paper-based system was used to store data. But this system had various drawbacks,
                  such as being prone to damage, editing problems, data repetition, and being difficult to manage.
                  Retrieving  data  from  file-based  systems  was  a  very  tedious  and  time-consuming  task.  To
                  overcome the problems in file-based systems, a computerised database system was introduced
                  in the 1960s.

                      CONCEPT OF A DATABASE

                  A database organises data in a manner that allows for efficient storage and retrieval of large
                  amounts of information. Although databases are a more recent development, they evolved
                  from older file-oriented data collection systems. Computerised data collection and manipulation
                  systems have  since replaced  these  conventional record-keeping  methods,  using application
                  programs to manage data. The components of a computerised database system are logically
                  related, facilitating easy access to data. The software required to store, retrieve, and manage data

                  in a database is known as a Database Management System (DBMS).
                      ADVANTAGES OF A DATABASE SYSTEM


                  A database system has many advantages. Some of the most important are:
                      It minimises the duplication of data by integrating and sharing the data files.
                      It saves storage space.
                      All the users are provided with some access rights or privileges and permissions.

                      The files can be easily updated whenever any changes are made.


                  82     Touchpad iPRIME (Ver. 2.2)–VII
   79   80   81   82   83   84   85   86   87   88   89