SMS to web gateway, process the data, update the database, connect database to website, make functional website.
These are not super complicated on their own, but having them work together well and meet user expectations/needs is another matter.
He can then sell the service or advertising on the page. Sounds like a startup business to me. Not huge or sexy but money in the bank if done well.