Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 92 - CoreGPT(Podar)_Flipbook_C8
P. 92

    Introduction to
                              7                         LibreOffice Base

                           Goal Glimpse

                               Concept of a Database                         Types of Databases
                               Advantages of a Database System               Database Objects
                               LibreOffice Base                              Data Types in LibreOffice Base

                               Creating a New Database

                      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
                                                                                                             LibreOffice Calc
                          of flat file database is LibreOffice Calc.

                     90     Premium Edition-VIII

| 87 88 89 90 91 92 93 94 95 96 97 |