Dear folks,
recently I'm exploring a database for R&D purpose use. Previously we were using Excel, but as time grows, the file size grows larger which I find it risky in terms of efficiency and data safety.
I'd like to link all the information of several projects, where the table would look like this:
Table 1
Project_List
- Project code
- Project name
Table 2
Trial_List
- Project code
- Project name
- Trial # (Unique ID combining Project code + the number of trials, Eg., ABC-1, where ABC is the project code and 1 is the 1st trial)
Table 3
Option_List
- Trial #
- Trial Options
- Machinery Settings
Table 4
Option_Results
- Trial #
- Trial Options
- Results A
- Results B
....
- Results Z
Would these something viable for my purpose? and is there any better options? I would like to learn on the relationship between the tables and the best form for these data...