Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Question Entities and relationships

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •