Help with Normalisation Process

[supermessiah]

Right, I've been through countless tutorials on how to normalise a database. It's something I have successfully done in the past, but quite a long time ago so I've forgotten a lot of it. Here is my UNF (normalised form) of a soccer match database:



UNF

Season
Tier
Division
Fixture
Result
Date
Status
Time
StadiumName
Attendance
RefereeName
First Half Goals
Second Half Goals

I'm struggling with 1NF. I'm having difficulty understanding the meaning of 'repeating data'. The tutorials I've been through say you need to separate the repeating and non-repeating data. Okay, but I can look at all of the above and say it's repeating, because... all of the data under each of those headings repeats somewhere. I'm confused about it.

I know that things from the above would have to be broken down during the normalisation process, such as 'Fixture', 'Result', 'RefereeName' and 'First Half Goals' & 'Second Half Goals', but I would appreciate any help for getting me started on this.

Okay, so for my attempt at 1NF, I've addressed the issue of having multiple values in each field by breaking down some of the headings. Problem is, the table split up into two (meant to be repeating and non-repeating data). However, I'm sure I've done this wrong. In the examples I've seen, they conveniently split up the table because they have appropriate data to fit into two tables. Looking at my set, I don't know how to split it into two without splitting up what is necessary in each table.

1NF

Season
Division
Status
Date
Time
StadiumName
Attendance

HomeTeam
AwayTeam
HomeGoals
AwayGoals
RefereeFirstName
RefereeLastName
HomeFirstHalfGoals
AwayFirstHalfGoals
HomeSecondHalfGoals
AwaySecondHalfGoals



Thanks.

[June7]

Repeating example would be a table of team members that has not only the individual info but all the team info, like:

Player	BirthDate	Address	Team	Coach	TeamDivision
Jim			1	Bob	Jr
Anne			1	Bob	Jr
Carly			1	Bob	Jr
Mason			2	Mary	Sr
Peter			2	Mary	Sr
Karen			2	Mary	Sr
Lucy			3	Steve	Pony
Linus			3	Steve	Pony
Larry			3	Steve	Pony

The team Coach and Division info should be in a table of Teams. Only the Team ID should be in the Players table.

[orange]

I think June7's example shows the repeating group aspect well. However, if you want a text tutorial on Normalization, there is a sample that goes through the procedure to normalize tables and create new entities and establish relationships.
see http://www.rogersaccesslibrary.com/T...lationship.zip