Page 86 - iPlus_Ver_2.0_class_7
P. 86

Database and DBMS—



                     An Introduction
                                                                                           7













                          Learning Outcomes


                              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                         Rules for Writing a Field Name in Access

                              Creating a Table                                 Adding a Record
                              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.

                   i +   CONCEPT OF A DATABASE

                  Database implies organising the data in a manner that helps to store and retrieve a large amount
                  of data efficiently. The database concept is one of the oldest ways to maintain records in a
                  conventional file-oriented data collection system.
                  Computerised  data  collection  and  manipulation  systems have  replaced  conventional
                  record-keeping  systems by using application programs.  The various components of the
                  computerised database system have a logical relationship that helps in accessing data easily.

                  A collection of programs required to store and retrieve data from a database is called a Database
                  Management System (DBMS).

                   i +   ADVANTAGES OF A DATABASE SYSTEM

                  A database system has many benefits. Some of the important benefits or advantages are:
                  •  It minimizes the duplication of data by integrating and sharing the data files.

                  •  It saves storage space.


                    84
                         iPlus (Ver. 2.0)-VII
   81   82   83   84   85   86   87   88   89   90   91