Hello
I have a problem. I want to view results from more than 3 tables. My problem is: what primary key i have to write in single table that in the final I can connect all 5 tables together?
I was thinking of creating one big table that will contain all the data. but reading on internet and forums i find out that is better to have separate tables with primary and foreign keys.
Imagine. you are doing some analysis. you have batch number. and you have to do 5 different analysis on that batch number. every analyisis will give you some results. your object in the final is : be able to see for every batch number the results for all 5 analyis together.
batch number has to be short text. batch number is like a model of mouse. exp. B145864. and that mouse have 5 analysis.
in every table i have batch number and depending on table field that give special results.
example.
I have 5 tables.
1. tblDsd give me results for Dv10, Dv50, Dv90 particle distrubution
2. tblSp give me results for DMax , DMin
3. tblVisko give me results for viscosity90, viscosity100, viscosity150
4. tblNozzle give me results for nozzle
5. tblApi give me results for Mean, stdev
what primary and foreign key shuld I write in every table?