Page 326 - TP_IT_V1.0_C10_flipbpookl
P. 326
Step 4: Click the Close button in the Add Tables dialog box.
Step 5: Click on Subject Code in Subject table and drag it to the Subject Code in Teacher table. Release the button to
see a relationship between tables, as shown below:
REFERENTIAL INTEGRITY
Referential Integrity is a fundamental rule in relational databases that ensures the consistency and validity of
relationships between tables. It deals with the rule that values of foreign key in one table is derived from the values of
primary key in another table to ensure that this relationship between two tables will provide accurate and consistent
data. In other words, no data which serves as a link between two tables is either deleted or changed by mistake.
Once the relationship between the two tables has been set, the integrity of data will be managed by the DBMS.
LibreOffice Base will allow only that corresponding record to be entered in the transaction table which already exists
in the master table.
324 Trackpad Information Technology (Ver. 1.0)-X

