table design feedback request for plating shop bath testing

[Dan Dungan]

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

 

[Vacuum Sealed]

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.

 

[Dan Dungan]

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