Many to many relationship Q
I have a Patient, Biochem range and Biochem tables.
1 patient can have many Biochem records, obviously 1 to many. However, 1 patient may several Biochem ranges in their lifetime and those ranges can apply to >1 patient. For the latter is better to have an intermediate table like 'Patient_age_Biochem range'?