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

    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
    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 "sqlblindman"

Posting Permissions

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