Article :: Design Your Database :: Database Naming Convention - The Diigo Meta page

• 02 Jun 12
  

  Geoffrey Van Wyk

  naming convention database coding standard mysql

• 15 Mar 10
  

  J Muller

  A naming convention should be used in the process of working with databases because of several reasons:
  It provides a clear structure, each component using the standard naming rules.The database logic can be understood by anyone knowing the naming convention.Maintenance work is reduced, as future developers will not have to waste time figuring out what each field is.Whatever the naming convention, make sure it becomes a standard across the company and is followed by everyone in your department. The following paragraphs presents the conventions InterAKT uses and recommends for developing web applications. In no way are they imposed, or the only ones possible to use.

  database naming conventions mysql database design

  • A naming convention should be used in the process of working with databases because of several reasons:

     
     
    • It provides a clear structure, each component using the standard naming rules.
     
    • The database logic can be understood by anyone knowing the naming convention.
     
    • Maintenance work is reduced, as future developers will not have to waste time figuring out what each field is.
     

    Whatever the naming convention, make sure it becomes a standard across the company and is followed by everyone in your department. The following paragraphs presents the conventions InterAKT uses and recommends for developing web applications. In no way are they imposed, or the only ones possible to use.
  • Do not use numbers in the names (e.g. product_attribute1). This is proof of poor design, indicating a badly divided table structure.
• 10 Mar 08
  

  mimi .

  database erd table uml

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.