Results 1 to 4 of 4
  1. #1
    daniel_l89 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2013
    Posts
    2

    Basic Bridge Management System

    I am working as an intern, completing an industry based project with an engineering firm. Successful completion of my project will serve as a possible incentive for employment when I graduate at the years end. I am currently a novice at Access, with some basic knowledge on database design. PLEASE HELP!

    The division I am working in performs "level 2" condition inspections on Bridges, where each component (approx. 50 in total, eg. deck, guard rails, abutments etc.) is inspected and assessed in terms of their defects and given a condition rating. Each component has corresponding attribute data (eg. material, geometry, exposure class etc.) An overall condition rating is then assigned to the bridge based on the weighted condition of individual components. I would like the system to have the following basic features:

    - Record the component attributes and conditions within the structure.
    - Record and score the bridge based on Deterioration attributes of the bridge (eg. environmental/locational data: high traffic volume, high exposure to salt etc.)
    - Produce an overall weighted bridge condition score, based on component and environmental/locational conditions.
    - Prioritise maintenance works across a number of bridges.
    - Ability to store photographs, technical drawings and other electronic documents on each bridge.



    I have started creating tables and filling in forms, here's an outline of my database design tables and a few fields:

    BridgeOverview:
    -BridgeID (autonumber), BridgeName, City, Suburb, AssetOwner etc. I would like this to be a basic overview of all of the bridge inventory.

    ComponentModule:
    -ComponentID (autonumber), Geometry, Modification, Group, Material etc. This is a detailed table of all components and their attributed. I have a number of drop down lists, but I would like a selection of a later drop-down to be dependant on an initial selection. There will also be a ConditionRating given to each component. Linked BridgeName to this table.

    DeteriorationModule:
    -DeteriorationID (autonumber), TrafficVolume, Exposure, Climate etc. This is a detailed table of deterioriation. Linked BridgeName to this table.

    This is basically all I have to date. I am unaware if my relationships are correct or if I may need further tables for Maintenance prioritisation etc.

    What I am wanting to learn is how I may be able to design this properly from the beginning and calculate overall scores of bridges for prioritising maintenance. I have tried to explain clearly what I am trying to achieve. This project is very important to me and any advise at all welcome. Thanks for taking the time to read my thread.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    If BridgeID is primary key then it should be the foreign key in Component and Deterioration, not the bridge name.

    Does the Deterioration data factor into the condition score?

    If you want cascading (dependent) comboboxes, will need table(s) that establish relationships between attributes Review: http://datapigtechnologies.com/flash...combobox2.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    daniel_l89 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2013
    Posts
    2
    Thanks, assigning the foreign key as BridgeID in Component and Deterioration makes more sense. I want the deterioration data to factor into the overall condition score.
    Overall structure condition it to be rated 5 (unsafe) through to 1 (new) based on the individual components condition. The deterioration is then to be used alongside these scores to further prioritize maintenance work.
    Eg. if 2 bridges are both rated condition 4 (very poor), the bridge that scores worse in terms of deterioration will be prioritized. I would like the deterioration module to run in conjunction with the component module.

    As for the combo boxes, thanks for your help! much appreciated. I am planning on finishing my relationship design in the next few days, any chance I could send it to you for a check. Just want to start heading in the right direction!

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Can provide files by attachment to post (instructions at bottom of my post) or embed images in the post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-29-2013, 05:46 AM
  2. How Imports System.Management in access 2007
    By Luu in forum Programming
    Replies: 5
    Last Post: 11-13-2012, 05:12 PM
  3. Employees Database Management System
    By salsai in forum Database Design
    Replies: 3
    Last Post: 01-22-2012, 12:45 AM
  4. Time and Leave Management System
    By P5C768 in forum Database Design
    Replies: 0
    Last Post: 03-10-2011, 11:20 PM
  5. ATM Cash Management System
    By NexusMike in forum Access
    Replies: 1
    Last Post: 08-09-2010, 12:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums