netpicker9 (12/8/2010)
Can any one please let me know how design tables below,1. Company
2. Client
3. Branch
4. Departments
Points:
a. Some companies do not have any branches and just departments
b. If company happen have any branch, do I need an entry in branch table for corporate office?
c. Is it better to use Branch, Departments tables for Company & Client tables?
I know this is basic but, I need your help!
I assume this is not being developed for a specific company but it is intended to be used to serve multiple companies you don't even know yet - is that a correct assumption?
If that's the case I'll make an executive decision and say "all companies have at least one branch - which is the company's headquarter"
Then, for a three "branches" company your database will show four e.g. headquarter plus three non-headquarters branches.
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.