Which is better in a database: one large table with columns that are often NULL, or many different tables?
Context: I work for a company that stores and analyzes data from inertial measuring units (IMU).
My teammates and I are considering creating and maintaining a DB for all the data we gather for analysis purposes (which is currently being saved in .csv files).
Create a snapshot table of other tables that have nested FK
Assume I have the following tables: