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
   290   291   292   293   294   295   296   297   298   299   300