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

