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

