Need help modeling multiple measurement formats while avoiding repeating attributes
First post, so please be patient ...
I'm a retired IT professional doing some volunteer consulting for a friend's small manufacturing business. I'm familiar with MS Access, DB2, etc. and have managed data administrators and DBA's, but am a little rusty on getting an effective data model put together. Target database will likely be MS Access with analysis reporting via Excel pivot tables.
The process I'm modeling involves capturing multiple kinds of quality measurements for a variety of process operations. One operation for an item may require capturing density, weight, a percentage of some sort of content, a qualitative "low, medium, high" opinion, hardness, etc. Another operation may have another entirely different set of measurements (each requiring different formats such as decimal, whole numbers, percentages, textual output, etc.).
I'm stumped how to model this to support multiple measurement formats without specifying each measurement type as its own attribute (violating 3rd normal form).
Thanks in advance for any help provided!
Last edited by BAWard; 02-27-16 at 17:27.
Reason: Add attachment