Handling the foreign keys in data entry
Foreign Keys don't automatically generate in the child referenced tables unless you use the CASCADE specifier in the declaration of the foreign key. See Why foreign key doesn't update? for more information on how to use CASCADE with foreign keys and alternative solutions.