Page 295 - TP_IT_V1.0_C10_flipbpookl
P. 295
UNIT Database Management
3 System using
LibreOffice Base
Topics Covered 95%
Data and Information Database
Data Model Relational Database Management System (RDBMS)
Creating a Database Using LibreOffice Base Opening a Database
Data Types in Database Creating a Table
Edit Table in Design View Inserting Data in a Table
Navigating Records in a Table Deleting a Table
Renaming a Table Closing LibreOffice Base
What are Relationships? Referential Integrity
What is a Query? Structured Query Language(SQL)
What is a Form? What is a Report?
A database is an organised collection of structured information or data, typically stored in tabular format. It is designed
to efficiently manage, retrieve, and manipulate data according to various criteria or requirements. Databases are widely
used in numerous applications, ranging from simple personal record-keeping to complex enterprise-level systems.
LibreOffice Base is a free and open-source relational database management system (RDBMS) included in the LibreOffice
suite. It provides a Graphical User Interface (GUI) for users to create, modify, and manage databases. LibreOffice Base
offers features for designing forms, creating reports, and querying data, making it a versatile tool for both individuals
and organisation requiring database management capabilities without the need for expensive proprietary software.
DATA AND INFORMATION
Data consists of raw facts and figures. It can be in the form of text, numbers, dates, images, audios, videos, etc. Some
examples of data are the name, age, and address of a student and the amount and price of an item bought from the
market. This collection of related data arranged in the form of rows and columns will form structured data.
The structured data can be classified as:
• Flat file: It stores data in a plain text format. The data is in the form of rows and columns, but data constraints cannot
be applied, and there are chances of data redundancy. For example: data created using tabs or commas in Word,
CSV file, Spreadsheet file, etc.
• Relational file: It stores data of different data types like text, number, and date in the form of rows and columns to
form a table. These tables are linked through a common field, so there are no chances of data redundancy.
For example:
• Numbers: 1, 2, 3, 4, 5
• Words: Apple, Banana, Cherry, Date, Elderberry
• Temperature readings: 25°C, 28°C, 30°C, 27°C, 22°C
• Time stamps: 9:00 AM, 10:00 AM, 11:00 AM, 12:00 PM, 1:00 PM
Database Management System using LibreOffice Base 293

