I have a large application that I am rebuilding as an Aurora/MySQL database. This has provided an an opportunity to start over with the naming conventions in my MS SQL database which has become a mess over the years. I am looking at incorporating some new rules and I am looking for additional pro/cons and rules I should follow.
2. Underscores separate words
3. Full words, not abbreviations
4. Prefix objects with application module name - I currently prefix objects with application module name that the object belong to. Is this a bad idea?