Page 85 - Trackpad_ipro 4.1_Class7
P. 85

Database and DBMS—


                            An Introduction



                                                                                   Chapter
                                                                                   07






                              Your Aim

                              to learn about:
                                 Concept of a Database          Advantages of a Database System
                                 Types of Databases             Terms Related to a Database
                                 Access 2019                    Components of Access 2019
                                 Creating a Database            Data Types in Access 2019
                                 Types of Views in Access       Naming Conventions for Writing a Field Name
                                 Creating a Table               Opening an Existing Database
                                 Exiting Access 2019


                 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, privileges, and permissions.

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






                                                                           Database and DBMS—An Introduction     83
   80   81   82   83   84   85   86   87   88   89   90