• Create store procedure that retrieve data that inserted in violation table and then insert it to the other table. matter of execution sequence..