Guidelines for Creating Table Names

  Previous section   Next section
  • Create a unique, descriptive name that is meaningful to the entire organization.

  • Create a name that accurately, clearly, and unambiguously identifies the subject of the table.

  • Use the minimum number of words necessary to convey the subject of the table.

  • Do not use words that convey physical characteristics.

  • Do not use acronyms and abbreviations.

  • Do not use proper names or other words that will unduly restrict the data that can be entered into the table.

  • Do not use a name that implicitly or explicitly identifies more than one subject.

  • Use the plural form of the name.


Part II: The Design Process