Guidelines for Creating Table Names

  • 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.

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.