How to name sql table and its category in sql server?

Question

I have table called Services and I want to make another table that have the Categories of services ( One-to-Many ) What's the best approach i can use to naming it is it one of the following ?

ServiceCategoreis
ServicesCategoreis
Serviecs_Categories
CategoriesOfServices

Answer 1

ServiceCategory

One row is one category for one service...?

Answer 2

You will find the "best" naming convention to be purely subjective. The database architects at my company argue that ALL_CAPS_UNDERSCORED_AND_SUFFIX is the "best" way to name database tables, which is unfortunate.

That said, I usually choose a naming convention that flows like natural speech, favoring a table name such as ServiceCategories, because the table contains "service categories".

A common point of discussion is whether to pluralize or singularize the table name (e.g., ServiceCategory vs. ServiceCategories). As more object relational mappers such as Linq-to-Sql, employ de-pluralizer techniques, I find that there's not much ground for dogmatically sticking to one practice or the other. It is probably in your best interest to decide once whether to pluralize or singularize your table names, then stick to it.