DB Design: identifying a subset of records from a table
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.