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

