Why attribute names should use suffixes?

Why attribute names should use suffixes such as ID, NUMBER of CODE, as part of database naming conventions?

There might be many objectives, one is to uniquly identify the whole record.