Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    12

    DB Design: identifying a subset of records from a table

    Hi,

    I have an entity call FOOTBALL_MATCH.
    Now I want to retrieve a list of the top 10 football matches for the week.
    Should I create another entity called FOOTBALL_MATCH_TOP_TEN which references the original FOOTBALL_MATCH entity or add another member in the original entity ? What are the pros and cons for both.

    Thanks.

    Regards,

    Legolas

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    suppose you had a table of football players

    which player has the most touchdowns? do you create a new entity? no

    which player has the fewest interceptions? do you create a new entity? no

    which player has played the most games? do you create a new entity? no

    which player has the most touchdowns? do you create a new entity? no

    rule of thumb: views aren't entities
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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