Page 87 - TP_iPlus_V2.1_Class7
P. 87

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                        Conventions for Naming a Field

                             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.

                  i +  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).


                  i +  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, privileges, and permissions.
                 •  The files can be easily updated whenever any changes are made.


                                                                                                                  85
                                                                            Database and DBMS—An Introduction
   82   83   84   85   86   87   88   89   90   91   92