search

gilienv / EssOilDB

Restructuring of Essential Oil Database
Apache License 2.0
8 stars 6 forks source link

Sample tables for database #52

Open petermr opened 5 years ago

petermr commented 5 years ago

Create a small subset (10-50 records) for each of the 14 tables. Create separate issues for each table (i.e. 14 new issues)

petermr commented 5 years ago

Each table needs a short document explaining

It also needs to be absolutely clear which columns are foreign keys in other tables.

petermr commented 5 years ago

FREQUENCY of values in tables.

Some values in tables look as if they only occur once or twice and we should be careful not to put too much effort into these. Can we dump the frequency of values so we only normalize the most frequent ones.

petermr commented 5 years ago

a Stackoverflow thread as to why you should almost never use lists in standard RDBs (which is what EssoilDB is). https://softwareengineering.stackexchange.com/questions/381460/is-it-ever-okay-to-use-lists-in-a-relational-database answer: almost NEVER

petermr commented 5 years ago

and another: https://stackoverflow.com/questions/3070384/how-to-store-a-list-in-a-column-of-a-database-table answer: DONT :-)