I have just a little experience in databases and I'm looking for help.
I'm designing the test database. The nature of test is to send data file to the device under test, get devise's response and compare it with expected response. For the same test the expected response and the data file may be different depending of the device under test or depending of device's options.
So, I created something like that:
Test_Data ================ Test_DataID (PK) Files TestID (FK) Responses ======== DeviceID(FK) =========== FileID(PK) -|--------<- FileID(FK) ResponseID (PK) FileCRC ResponseSetID ->---<- ResponseSetID TotalResponses Dependency1 ResponseNo Dependency2 ResponseValue Dependency3 Dependency4
to be continued...