Re: database design

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.