Plant chemistry db to collect millions of little bits of data which in aggregate can flesh out the story on the effects on humans. This differs from the usual business db in having much variability and lots of nulls. The five main entities are plant, chemical, MOA, effect and references. The goal is to search on any one or two for the others. If you’re into health and nature this could be fun for you.
Stage 1 is to review the tentative data model and schema and provide constructive criticism and finalize normalization and de-normalization.
Stage 2 is to populate with data I have from a few sources and some web scraping from government sites. Also, setup entry and query forms.
Stage 3 is to put it up on the web for public use.