SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast almtechnology's Avatar
    Join Date
    Sep 2006
    Location
    Karachi,Pakistan
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Asp Application at multiple location

    i m developing General Ledger application in asp.my company is located head office at south and is branch office in west
    so i have to developed an application that data related to south they can post there data.so as well as west.now problem is that what techniquei should use.In my opinion i can create administrator login form where person in south
    can log on with it and enter his data while same as person in west. or what should i use
    ALM TECHNOLOGY

    MUHAMMAD IRFAN MOTIWALA
    CELL (92)0333 3966779

  2. #2
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    that sounds fine. i'd have a region table - that way it will scale better if/when adding more regions in the future. use the ID's as foreign keys in the other tables (ie: data, users) so that the appropriate data is displayed to the appropriate user.

  3. #3
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Bill's advice is spot on as usual. The formal term for this is Normalisation. Think about the database structure, and where there could be data elements that might expand in scope in the future.

    The region is one example - at the moment you have South and West ... what if the company expands or changes in the future and needs North and East? If you have a Regions table then this is easy - you simply add the new regions to the table, and then when data is added in other tables it simply relates to the RegionID number.

    The big benefit of this approach is that it makes database applications much more scalable, and also tends to reduce the database size ... a number like 1, 2, 3 or 4 takes up less space than North, South, East or West ... and if you expand that to 10,000+ data rows you can see how much better things are starting to look.
    Ian Anderson
    www.siteguru.co.uk


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •