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
   321   322   323   324   325   326   327   328   329   330   331