0 normal form, 1st normal form....

[dict]

Hi there,

I am currently doing a data base on a soccer tournament. However, i need help to explain my data using normalized data model.

the data are as shown:

Under soccer tournament: Match Id, Team ID, Pitch Id, Referee Id, Score, Start Time

Under Pitch: Pitch Id, Pitch no.

Under Referee: Referee Id, Referee Name, Referee Tel

Under Team: Team ID, Team Name

Under Players: Players Id, Team Id, Players Name, Players Age

How do i form a normalized form starting from 0 normal form up to the necessary normalized form?

Thank you!

[orange]

Start here
http://www.rogersaccesslibrary.com/forum/topic238.html

[BenB]

Try this link: http://www.about-access-databases.co...alisation.html

Other related links: http://www.about-access-databases.com/primary-key.html

From http://www.about-access-databases.com