HI I am currently designing a website which contains games for children. I need to design a database to store the results of the games and graphics for the games. I am a bit confused about my entities. I have a 1 to many relationship between user and game and i am not sure where the results entity will fit in. Is it derived from the relationship between user and game or is it directly related to both or either of these entities?Any suggestions would be greatly appreciated. Thanks.

I think that you need a new entity, which I'd call playInstance. User and game would both be non-identifying foreign keys in playInstance. Score would be an attribute of playInstance.

-PatP