Question

Why are naming conventions important in designing a database?

Answer 1

Naming conventions are important in designing a database for many reasons. Below are reasons why naming conventions are important:

➢ A naming convention is an important part of a well-built data model.

➢ Naming conventions give us clear and concise names for tables, procedures, etc.,

➢ By naming conventions, we can get a clear idea about what the table contains. In case you have hundreds of tables and you don’t want it to be a mess you should use naming conventions.

➢ Naming conventions makes searching for the relevant procedure/table easier.

➢ Naming conventions gives the ability to acquire knowledge without recourse to conscious reasoning for someone who is learning the system.

➢ It helps to keep your database from becoming an unmaintainable mess.

➢  It increases the overall readability of the model, and you’ll spend less time finding what you need.

➢ Using naming conventions the database shall live for a long time.

For example CreateTabBasedOnSourceFile, here just by seeing the table name you'll get an idea for what's gonna happen when you run the procedure.