Hi,
When a customer is deleted, his or her contacts should also be deleted from the database.
I am missing the database dependency between clients and contacts table? Why is there no dependency for such cases?
PS: It should also be checked whether there are further dependencies missing in other places and thus data corrupt.