archiving weekly data from a sports league

[20sunflower]

Hi

I'm trying to design a database for a sports league, but am having difficulty working out how i would keep weekly data and archive it in some way in order to input the following week's data.

Any help appreciated.

 

[Galaxiom]

Include a date field on each record.

 

[20sunflower]

Include a date field on each record.

Thanks for your reply. Do I create a table with week 1's date and the scores and then a table with week 2's date and then the scores and make the week ID the primary key?

 

[Galaxiom]

I imagine you have scores for several teams. If you have a field for each team then you could use either the date or a WeekId as the PK.

However it is more normalized to include a separate record for each team or fixture so the date or WeekID could not be a key.

 

[20sunflower]

I imagine you have scores for several teams. If you have a field for each team then you could use either the date or a WeekId as the PK.

However it is more normalized to include a separate record for each team or fixture so the date or WeekID could not be a key.

Can you explain this to me because I don't follow what you are saying. I'm a beginner at databases. Would I use Player ID instead to track each player's fixtures?