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

