table design feedback request for plating shop bath testing

Discussion in 'Access Table Design' started by Dan Dungan, Apr 4, 2012.

  1. Dan Dungan

    Dan Dungan Guest

    I'm using Access 2003, windows xp professional operating system, and
    I'm having difficulty creating the forms for data entry. I'm starting
    to suspect the table design may be missing something; so, I'd like
    feedback on my table design.

    Purpose of database:
    The purpose of this database is to track plating solution titration
    and how much of a specific chemical was added to the solution to bring
    it back to its correct mixture. We want to find out how to keep the
    plating solution at the proper mixture.


    Rules:
    In a plating shop there are many tanks.

    Each tank has a mixture of several chemicals. This is the plating
    solution for that tank.
    There are different plating solutions for different types of finish,
    cadmium, nickel, copper, etc. Many tanks contain the same plating
    solution. Not all tanks contain the same plating solution. Each tank
    has one plating solution.

    A specific chemical can exist in several solutions at different
    percentage of solution.

    The chemistry in the tank changes as more parts are exposed to the
    solution. The titration is a test to determine if the chemistry of the
    tank has changed enough to require additions of more chemical.

    Each tank is tested. One test can have many results--one for each
    chemical.
    One tank can have many tests. The plating solution temperature and ph
    are taken for each test. There is a minimum, maximum and optimum
    temperature and pH for each tank. I need to display these in reports
    and on the data entry forms.

    Each test result may require an addition of more chemical. If the
    plating process is electroplating, the result is ounces per pound of
    solution. If the plating process is electroless plating, the result is
    shown in a percentage of the total quantity of plating solution. Each
    titration has a minimum, maximum and optimum result in either
    percentage or ounces per gallon. Each titration may or may not require
    an addition. Each titration result has a multiplier that I must store
    for each chemical to determine the result of the test. Some of the
    chemicals have more than one multiplier. I need to clarify this rule.
    I don't know what the multiplier is yet.

    I've included the table design at the bottom of this post.

    I respectfully ask your feedback about this table design strategy.

    Thanks,

    Dan
    ----------------------------------------------------------------

    tblTank
    TankID
    TankTypeID
    Tank Number
    Tank Size

    tblTankType
    TankTypeID
    TankTypeDescription
    TempLow
    TempHigh
    TempOpt
    pHHigh
    pHLow
    pHOpt


    tblChemistry
    ChemistryID
    Chemical
    ChemicalElementSymbol
    RangeLow
    RangeHigh
    RangeOpt
    Multiplier

    tblTankTypeChemistry
    TankTypeID
    ChemistryID

    tblTest
    TestID
    TankID
    TankTempuratureResult
    TankpHResult
    TestedBy
    TestedDate
    TestedTime
    Notes

    tblTestResults
    TestResultsID
    TestID
    ChemistryID
    Vol
    Oz/Gal
    AdditionDate
    AdditionTime
    AmountAdded
    PercentAdded
    Notes
    AddedBy
     
    Dan Dungan, Apr 4, 2012
    #1
    1. Advertisements

  2. Hi Dan

    Did you not post this in Excel NG as your boss didn't want to use Access.

    He's had a change of heart then... :)

    One thing though, in the Excel examples you put forward, you mentioned
    weight e.g 200lbs.

    In your tblTestResults you have Vol & Oz/Gal so It may be prudent to
    include a "Specific Gravity" field for those Chemicals that are +/-
    Zero(0), eg:

    Toluene's SG is: 0.865

    yet

    Toluene DiIsoCyanate's SG is: 1.22

    So you would put more of one, and less of the other if you are using
    just the weight scale.

    You may well already have this in mind and under control, just thought I
    would raise the subject.

    Cheers

    HTH
    Mick.
     
    Vacuum Sealed, Apr 5, 2012
    #2
    1. Advertisements

  3. Dan Dungan

    Dan Dungan Guest

    Hi Mick,

    This is the same plating department, but a different request from the
    boss. This part is for tracking titration results. So I'm not keeping
    the material weight here yet.

    Dan
     
    Dan Dungan, Apr 9, 2012
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Lynn Trapp

    how do I set up intergrated system for flower shop ?

    Lynn Trapp, Jan 13, 2005, in forum: Access Table Design
    Replies:
    1
    Views:
    93
    John Vinson
    Jan 13, 2005
  2. cdalesteve600

    Table for shop scheduling

    cdalesteve600, Apr 6, 2005, in forum: Access Table Design
    Replies:
    1
    Views:
    96
    Scott McDaniel
    Apr 6, 2005
  3. thedrumdoctor

    Early stages of shop-stock database design

    thedrumdoctor, Nov 14, 2007, in forum: Access Table Design
    Replies:
    3
    Views:
    123
    Lance
    Nov 15, 2007
  4. ESheehan

    Feedback on my db's logical relationship design

    ESheehan, Mar 19, 2008, in forum: Access Table Design
    Replies:
    4
    Views:
    73
    tedmi
    Mar 20, 2008
  5. madam

    waste water pumps work shop design

    madam, Nov 19, 2008, in forum: Access Table Design
    Replies:
    0
    Views:
    114
    madam
    Nov 19, 2008
  6. Dmarie

    a banner for new shop sale/make vintage jewlery

    Dmarie, Dec 3, 2008, in forum: Access Table Design
    Replies:
    1
    Views:
    108
    John W. Vinson
    Dec 3, 2008
  7. twodoor55

    School Print Shop Database

    twodoor55, Mar 8, 2009, in forum: Access Table Design
    Replies:
    2
    Views:
    118
    Ken Snell MVP
    Mar 8, 2009
Loading...