I have a Table with a list of Tests (one record for each test).
I need to create Table(s) with normative data for evaluating results of tests accordingly with Age and Gender.
Basic fields would be:
Age (from 5 to 19)
Gender (M or F)
Test_Name (about 50 different tests)
Since the Expected_Value and Standard_Deviation may change with time, I want values to be entered avoiding calculated fields.
Should I have one Table with 1 record for each Age and each Gender and each Test (15 x 2 x 50 = 1500 records) or should I split in two Tables ?
Many thanks for your suggestions,