Write some Software

I have a chat notification database table showing the unread messages. All i need is someone who can help me write a code to reflect these tables and add a link to the relevant projects so that the user knows when they have a new message. There is also an existing module for these types of notification but doesnt include the unread chat messages. Kindly have a look at the picture i have attached showing what i need. Regards! Thank for your help!