There sre several rules that must be applied naming the tables and Feilds also designing the database feilds.
Names for all database elements should be Unique, Meaningful and Short.
Restrictions for naming tables:
• Use no acronyms or abbreviations, Should be descriptive to convey meaning.
• Should not imply more than one subject
Restriction for naming fields:
• No acronyms
• Use abbreviations only if clear and meaningful
• Must not imply more than one subject
• Must be singular.
At the time of designing database fields, one thing should be kept in mind that it is required to set the properties of the fields.