When designing a database it’s a good idea to follow some sort of naming convention. This will involve a little thought in the early design stages but will save significant time when maintaining the finished system.
It’s less important which exact conventions you choose to follow – but this page has a few suggestions.
The benefits of using a naming convention are more to do with human factors than any system limitations – but this does not make them any less important.