Post reply

Design question

  • August 29, 2006 at 1:34 pm

    #367193

    I've hit a snag on a project I'm working with here's the scenario.

    I have a list of health facilities. These health facilities exist in a physical location. The facilities can be grouped by counties, parishes, districts,or anything. The counties/group can be grouped into a higher grouping level e.g. Trauma Regions, Emergency medical Service regions or anything. Facilities can exist in more than one grouping. A Group can also be grouped by an infinite number of higher level groups e.g. State, Country, Province etc.

    Basically i want to be able to dynamically create an infinite number of groups for my facilities(note groups can be grouped).

    Does anyone know how to model this correctly and effeciently?Thanks in advance.

  • August 29, 2006 at 1:49 pm

    #657378

    Here is the first stab.

    1.FacilityMaster Object

    FacilityID,Name,Address,City,State,County,District...

    2.GroupMaster Object

    GroupMasterID,GroupName,State,County,District...

    3.Facility_X_Group

    FacilityID,GroupMasterID,...

    Hope this helps.

    Thanks

    Sreejith

  • August 29, 2006 at 1:55 pm

    #657380

    Thanks. That solves the facility part

    What about groups in groups?

  • August 30, 2006 at 9:08 am

    #657562

    I haven't examined the query writing end of this but you can:

    Group_X_Group (ChildGroupMasterID, ParentGroupMasterID)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply