The Database Naming Convention is a standardized methodology of naming tables and fields in the database. The methodology is designed to;
•Make the data model self-documenting so an individual can understand the table relationships without having to refer to a data model map
•Minimize the possibility of having duplicate field names in the database
•Simplify writing SQL statements; not necessary to be verbose by including the table name for every field in the SQL statement.
•Make it easier to perform global Find and Replace on field names and table names (like trying to rename a field named “description” or “id”)
•Make sure reserved words are not used as field names or table names (like “Status”).