from UNF to 1NF ... newbie question ....

Hi all,

If I have repeating-groups (3 levels deep), how do I seperate them to go to the 1NF?
I have doubts/questions about assigning the key's.

According the rule:

1. duplicate the primary key and add a key of the repeating group.

question:
What is considerate the primary key for the 2e level repeating group? Is it the UNF-key + 2e level-key or is it the combined key (UNF-key + 1e level key + 2e level-key.)

Practical problem:

I have a (biljart) match played between 2 teams. (A team consist of 5 players)

A match is finished when the 5 players played a game against the oposite team-player. (5 games)

I need to keep track of the individual scores AND the Team-scores

UNF: Matchnr
date
every match (level1)

    teamname
    every game (level2)

        nr of attemps
        every player (level3)
            playername
            score

 Thanks for your advice ...

Jos Received on Mon Aug 27 2001 - 13:56:02 CEST