Question

7. Create a reusable stored procedure named “delete_person" that takes only one parameter, the username of a person, and deletes all record of that person from the database. This means

deleting all of a person's posts, likes, and the Person record itself.Execute the procedure to delete a person of your choosing (make sure the person has at least one post and at least one like). List out all three tables to show that all record of the person is gone.

Question image 1