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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
