Guidelines for Creating Field Names

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

  • Create a name that accurately, clearly, and unambiguously identifies the characteristic a field represents.

  • Use the minimum number of words necessary to convey the meaning of the characteristic the field represents.

  • Do not use acronyms, and use abbreviations judiciously.

  • Do not use words that could confuse the meaning of the field name.

  • Do not use names that implicitly or explicitly identify more than one characteristic.

  • Use the singular 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.