Is this normalised in 1NF 2NF and 3NF? if not what do I need to do?

Question

Tournaments

Date
Names
Scores
Venue
Winner

Consists of many

Matches

Date
Names
Scores

Many Matches consist of many

Scores

Date
Names
Server
Serve
Return
In/Out
Winning point
Area
Distance
Contact

Answer 1

You have NAMES is all 3 tables. Is that TournamentName, MatchName, TeamName, or PlayerName?

Same thing with DATE

You need a MatchID field to link the One tourney to Many Matches by the Matches Table primary key

SCORES should probably link to Matches but not to Tournaments, and you need a ScoresID to link

I don't see how Area, Distance, or Contact have anything to do with Scores, though I don't know what game this is for.

I would think a 4th table called Statistics might be appropriate for some of the data in the Scores table

Answer 2

My query looks something like this:

SELECT DISTINCT a, b, c FROM aTable WHERE rownum <= 1000

but it returns 987 records because of the distinct, how to really get a 1000 records, I don't want to do this:

SELECT * FROM (
SELECT DISTINCT a, b, c FROM aTable
)
WHERE rownum <= 1000

since the performance would be horrible!

Answer 3

Don't worry; I totally know exactly and completely what you are trying to say. Go to your local clinic......and.....ask for......a burger.