street connection of alarmobject updated with foreign key constraint