Page 234 - IT_V1.0_Class10
P. 234

Unit-3 DATABASE MANAGEMENT SYSTEM USING LIBREOFFICE BASE






                10         WORKING WITH MULTIPLE
                           TABLES









              In the previous chapter, you learned the process of creating tables within a database. After adding tables to
              a database, you may need to modify or remove them. Additionally, establishing relationships between tables
              is essential for minimising data redundancy and ensuring consistency. By avoiding duplicate records and
              guaranteeing that the values for a certain field are constant across several tables, this technique is essential to
              efficiently managing the database. Any modifications made to a record in one table will instantly be reflected
              in all of the associated tables after relationships between tables have been established.

                 EDITING AND DELETING TABLES

              In LibreOffice Base, editing and deleting a table allows users to manage and organise their database effectively.
              Editing a table involves modifying its structure, such as adding or deleting fields, changing field types, or
              updating properties to meet data requirements. Deleting a table permanently removes it from the database,
              including all its records.

              Editing Table Design

              LibreOffice Base allows to modify the structure of the table even after creating and saving a table. The user
              can add new fields, remove existing fields or change the properties of the existing fields.

              Adding Columns/Fields

              Perform the following steps to add a new column/field:

              Step 1:  Right-click the table from the Tables pane in which column/field is to be inserted. In our case, we
                       have right-clicked the Student table.
              Step 2:  Click on the Edit option from the context menu.

                       The Student table opens in the Table Design window.
              Step 3:  Type the name of the field, its data type and set the properties.

              Step 4:  Click on the Save button in the Standard toolbar to save the table.



                                                             4







                2

                1                                            3




                232     Information Technology Play (Ver 1.0)-X
   229   230   231   232   233   234   235   236   237   238   239