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.
