I am trying to set up a staining quality db to monitor stains we prepare in-house to stain cell biopsy samples. Basically, we make a stain solution, that solution is composed of "ingredients." Each ingredient has a manufacturer lot number. When we make a batch, we assign our batch an in-house lot number as well as preparation date. Then we stain a control sample and evaluate the staining quality.
The ingredients always remain the same, but their lot numbers may change. Each time we make a new batch, we assign a new lot number to it.
Below is a diagram/example. I need assistance in figuring out how many tables to create and setting up the relationships. Thank you for any help you may offer.
Date Prepared Lot Number Quality Evaluation Hematoxylin Stain 1/1/2017 1 Acceptable Component 1 Hematoxylin dye A123 Component 2 Aluminum potassium sulphate B234 Component 3 Sodium iodate C345 Hematoxylin Stain 2/1/2017 2 Acceptable Component 1 Hematoxylin dye A123 Component 2 Aluminum potassium sulphate B234 Component 3 Sodium iodate C345 Hematoxylin Stain 2/15/2017 3 Unacceptable Component 1 Hematoxylin dye A890 Component 2 Aluminum potassium sulphate B555 Component 3 Sodium iodate C710