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

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