Database Design Question (Not sure how to design this part)
I'm not sure how to design this part of my database but I can tell you how it will be on the front end part. Can someone help me with this?
The front end is going to look like this:
Depending which student is selected, the amount of tests can change, so student B could have Test 1-5 whereas student A has Test 1-3
Testing Information For student A
| Time | Test 1 | Test 2 | Test 3 |
| 8:00 | 3 | 5 | 2 |
| 4:00 | 7 | 2 | 3 |
| 2:00 | 4 | 5 | 1 |
| 9:00 | 7 | 0 | 1 |
Does this make sense?
Basically, the table can expand both ways, there isn't a fixed amount of columns so I'm not sure how to record this or design it.