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

    Struck with EER Diagram for soccer league...

    I have asked to draw an EER diagram for an assingmnet. i drew all the entities and relationships but at last there is a problem to draw away and home matches.
    Each team plays every other team twice (once at home and once away). how to draw this on ER.. I dont understand the logic..

    and the other thing is

    Teams are also described by the city in which they are located and the division and league in which they play (such as premier division or first division). can we use team as superclass and 1st and premier as subclass..

    Thankz in Advance..

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    This is a difficult scenario to model, and there are more than one or two ways to do it.
    We can't help you on the relationships without seeing the model you have come up with.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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