I'm creating a database of simulation results, and am trying to do so the right way. I've attempted to show relationships between data to make sure nothing redundant is thrown in.

My current structure is like this:

**Experiment**

Primary key: SimulationID

Tables:

* measurement
* sampling\_rate
* first\_draft\_flow\_rate
* second\_draft\_flow\_rate
* final\_flow\_rate

Foreign key relating these tables: cycle\_count

Each table contains the primary key, foreign key, and values for the variables.

So for a given experiment, it runs for so many cycles (the number of cycles it runs for varies from simulation to simulation). We log data at each cycle of the simulation.

I've made a table called `measurement`, `sampling_rate`, etc, but am not sure what to name the columns. Should the also be called `measurement`, `sampling_rate`, etc? Or should I just use `Value` as the column name? 

Here's a spreadsheet with a sample log to demonstrate what I'm working with. All of this data would be filed under a single `SimulationID`.

[![spreadsheet](https://i.stack.imgur.com/hWr8G.png)](https://i.stack.imgur.com/hWr8G.png)

Also, any tips on how best to design a DB to be normal/best practices would be greatly appreciated.