Hi Kalai,
From the vagueness of your question, it sounds like you need a DBA to design the database.
But basically you need to put the branch id as a foreign key in all data tables and then you can generate reports grouped by date or portion thereof, branch or company.
Sim
On 02/15/2011 08:45 AM, Kalai R wrote:
hi,
We are going to design database for a large company, which has many branches. In each branch they maintain data separately and also they maintain year wise data. ie
Company
|
Branch
|
Yearly
Also we need to compare and prepare reports by combine all branched data.
How should we design the database. Please Give Guidance.