I have a client doing scientific research. The current database design is 3NF but very few transactions are happening. There are several “pipelines” that add new data to the tables and scientists might make an update to some data or “discard” some data as erroneous but overall very little is happening transaction wise.

I started working in a new company, where my manager has this proposal regarding one of the tables.