added code to remove the corresponding record from the
announcement_interest table