Wednesday, November 10, 2010

Database Naming

Generally designing a DB can definitely be overwhelming and more so when there are a lot of tables that need to be created to put the work-flow in order.
At such a point of time naming your tables can be a bit hectic. Also when you tend to explain the design to an external person it can be bit problematic as to relate the tables to the business logic.
One method that I did learn recently was to associate your tables with the business elements. For example of you have a business element, say a User then started all the tables related to the user with a "U_" tag can be helpful in presenting the model.
e.g. U_User or U_Role etc.
Hope this helps someone.

No comments :