Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2013
    Posts
    6

    Unanswered: Workbench diagram example

    I'm trying to figure out how I would model a UML diagram (using workbench) from a past exam paper. Here is the original question:

    http://www.dbforums.com/attachment.p...1&d=1388873751

    My initial intuition was to create a one-to-many relationship between player and match and player and training session, like this:

    http://www.dbforums.com/attachment.p...1&d=1388874462

    I then realised that this doesn't really allow me to put stats for what a single player does in a match. I thought about trying it with a one to many relationship between player and match to accomplish this, but that would end up with duplicate matches which seems like bad practice to me. Do I need to work in some other form of table to account for an individual player's statistics in a single match?

    I haven't been doing databases for long (and mySQL in particular), so I could use some help with understanding this. Thanks!
    Attached Thumbnails Attached Thumbnails Screen Shot 2014-01-04 at 22.12.35.png   Screen Shot 2014-01-04 at 22.20.03.png  
    Last edited by Meloda; 01-04-14 at 18:28.

Posting Permissions

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