Hi Guys,
I want to design and build an HR module that will include
1. Organization
2. Sites
3. Departments
4. Costcenters
5. Designations
6. Employee Profile etc.


I need guidance and your expert opinion on which structure will be better
1. Create Organization table, Sites table and another table of Org_Site_map (which will be used in further application void) Or
2. Create Organization table and Sites table and add reference column of OrgID in sites table.

Will appreciate your help in decision making.