Page 327 - TP_IT_V1.0_C10_flipbpookl
P. 327

Referential Integrity helps in the following conditions:
                 •  Whenever a new record is added in a table with the foreign key then it ensures that the value added should exist in
                   a primary key of the other linked table.
                 •  Update or deletion in the Table with the primary key is not allowed if the matching record exists in the foreign key
                   of the other table.

                 Edit Relationship
                 Editing  relationships in  Base involves modifying  existing  connections  between tables  to  meet evolving  database
                 requirements.

                 The steps to edit a relationship are as follows:
                 Step 1:  Right-click on the relationship thread and select the Edit option.


























                         The Relations dialog box opens.








































                                                                        Database Management System using LibreOffice Base  325
   322   323   324   325   326   327   328   329   330   331   332