There is an app to create groups and you can assign a ring tone for each group.

There is however a separate app that does allow you to assign a ring tone for a single contact.

I am no expert but if you ask me I find it disgraceful that you need apps on the N900 to do things Nokia phones have been doing out of the box for over ten years. Talk about moving backwards.