You must insert a valid foreign key value (zone_id) from zone_details, otherwise the link between the 2 tables is broken, for example:
insert into Lot_details(Lot_size, zone_id) values ('11450', (select zone_id from zone_details where zone_name='A'));
Refer:
sql_foreignkey[
^]