Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

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.