Page 22 - TechPluse_C8_Flipbook
P. 22

Introduction to
                         2                          LibreOffice Base

















                      Your Aim

                      to learn about:
                         l    Concept of a Database             l    Types of Databases
                          l    Advantages of a Database System     l   Terms Related to a Database
                           l   LibreOffice Base                     l   Data Types in LibreOffice Base
                            l   Types of Views in LibreOffice Base         l   Rules for Writing a Field Name in LibreOffice Base
                             l   Creating a Table                        l  Exiting LibreOffice Base

                  In earlier days, files made up of paper and cardboard were used to store information and data.
                  However, such files were prone to damage. These files also posed problems while editing and
                  management. There was data repetition across the files as the data cannot be verified from

                  multiple files easily. Retrieving data from file-based systems was very tedious and time-consuming
                  task.  The  computerised  database  system  of  1960s  offered  an  excellent  alternative  to  the
                  paper-based database system.

                      CONCEPT OF A DATABASE
                  Database implies that organising the data in a manner which helps to store and retrieve a large

                  amount of data efficiently. It is one of the oldest ways to maintain records in a data collection
                  system.
                  The 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 Database Management System (DBMS).

                      TYPES OF DATABASES

                  There are mainly two types of databases:

                       Flat File Database: It is a type of database that contains records having small
                      number of fields without any structured relationship between them. The most
                      popular example of flat file database is LibreOffice Calc.                         LibreOffice Calc
                       Relational Database: It is a type of database that stores data in several tables and links
                      those tables together to get a common piece of information. Commonly used relational
                      database systems are LibreOffice Base, Microsoft Access, etc.





               20       Premium Edition-VIII
   17   18   19   20   21   22   23   24   25   26   27