Re: database design

Sim Zacks <sim@xxxxxxxxxxxxxx> · Tue, 15 Feb 2011 09:27:40 +0200



    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.