Page 23 - Touchpad_Plus_V3.2_Class 8
P. 23

Introduction to
                          2                          LibreOffice Base

















                     Your Aim

                     to learn about:
                             Concept of a Database                 Types of Databases
                              Advantages of a Database System         Terms Related to a Database
                               LibreOffice Base                        Data Types in LibreOffice Base
                               Types of Table Views in LibreOffice Base      Rules for Writing a Field Name in LibreOffice Base
                                Creating a Table                            Closing a Database and 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  a  very  tedious  and  time-
                 consuming  task.  To  overcome  the  problems  in  file-based  systems,  computerised  database
                 system was introduced in 1960s.

                     CONCEPT OF A DATABASE

                 A  database  is  an  organised  collection  of  structured  data  that  is  stored  electronically  in  a
                 computer system. It allows for efficient storage, retrieval, and management of large amounts of
                 information. Databases are designed to support multiple operations, such as querying, updating,
                 and managing data, while ensuring accuracy, security, and consistency.

                 They are commonly used in various applications to manage records, such as customer information,
                 inventory, and financial transactions.
                 A Database Management System (DBMS) is software that allows you to create, manage and
                 interact with databases. It allows users to store, retrieve, update, and delete data efficiently.

                     TYPES OF DATABASES

                 There are mainly two types of databases:
                     Flat File Database: Data is stored in a single table, usually in a plain text file.

                    There are no relationships between data points. Each record is independent,
                    and there’s no way to link data from different files. The most popular example
                    of flat file database is LibreOffice Calc.                                         LibreOffice Calc


                                                                               Introduction to LibreOffice Base      21
   18   19   20   21   22   23   24   25   26   27   28