CODE EXAMPLE FOR SQL

ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails

Its Simple

Use user brain and eyes 
and check dose all data add into the patients table

Sp-  Don't trust your friends