Page 93 - Computer Software Application TP - Volume 1
P. 93

COMPUTER SOFTWARE APPLICATION - CITS


































           Ensure that each table’s primary key constraint is enforced. MySQL automatically enforces primary key constraints,
           preventing the insertion of duplicate keys.
           3  ON DELETE/UPDATE Actions: Specify how the database reacts when data in the parent table is modified
              (e.g., ON DELETE SET NULL sets foreign key to null, ON DELETE CASCADE deletes related rows).
           4  CHECK Constraints: Define custom conditions for valid data (e.g., age must be positive).

















































                                                           78
                               CITS : IT & ITES - Computer Software Application - Exercise 24
   88   89   90   91   92   93   94   95   96   97   98