Page 86 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

7 Test Data Integrity: Try to insert data that violates the integrity rules you’ve defined. For example, try to insert
an employee with a department id that doesn’t exist:

INSERT INTO employees (name, department id) VALUES (‘Adam’, 10);

You should get an error because the department id 10 doesn’t exist in the departments table.
Update and Delete Data: When updating or deleting data, make sure to maintain referential integrity by updating
or deleting related records appropriately.
Review and Modify Rules: Regularly review your data integrity rules and modify them as necessary to ensure
they continue to meet the requirements of your application.

We can use the graphical interface of phpMyAdmin to manage tables and constraints.

71
CITS : IT & ITES - Computer Software Application - Exercise 22 CITS : IT & ITES - Computer Software Application - Exercise 22