I am developing a database for the recording of Volleyball results. I have a fixture database that tells me who plays who in each round.
Teams Table, say IDs 1,2,3,4 Fixtures Table, Round No.1, Team 1 (Team.ID) v Team 2 (Team.ID)
Results is harder and I am stuck on the schema. Each Volleyball game is best of 5 sets, so it can be 3, 4 or 5 sets long. I need to record Fixtures.ID, Team1.Set1, Team1.Set2, Team1.Set3, Team1.Set4 and Team1.Set5 (and same for Team 2). Is this the best way of doing it, or should some normalisation process have an entry like Result.ID, Fixture.ID, Result.TeamID, Result.SetNo, Result.SetScore