Chemistry Reference
In-Depth Information
The vast majority of chemical information consists of text or numeri-
cal data associated with a particular compound, or perhaps a mixture of
compounds. Some chemical data cannot yet be associated with any par-
ticular structure, or has been measured for compounds whose structure is
not yet known. It is important to consider these possibilities when design-
ing a schema of tables to store chemical information.
6.3 Sample Schema for Tracking
Chemical Samples
These are the operations that are required by users of this compound
tracking system:
•
Register a sample and record the chemical compound(s) it contains.
•
Checkout the entire sample, or subsamples, recording the person
(chemist), location (lab), and date and time.
Return a sample to a location.
•
These are the questions that need to be routinely answered by users of
this schema:
•
Which sample(s) contain a particular compound?
•
Where is and who has any or all samples of a particular compound?
•
Where has a particular sample been since it was registered?
•
Which compound(s) are contained in a particular sample?
•
What is the molecular weight of a particular sample?
These are possible future requirements:
•
Location may need to be expanded to identify particular shelves,
cabinets, or drawers.
Samples may need to be tracked as controlled substances.
•
These are the items that need to be stored in the schema:
•
Sample
•
Compound
•
Chemist
•
Location
•
Time and date
•
Molecular weight
•
Checkout
Search WWH ::
Custom Search