[faragerri]

I have been working trying to work out an scheme of a result database for my track and field club. As I am relatively new to MySQL and PHP, I would like to know from you, if you can give me any tips how I can improve the attached database model.

Thanks a lot!

The newest model can be seen here:

http://www.faramelli.com/php/database.png

[MikeMackay]

That's actually not all that bad, you seem to have normalised your database quite well. I'm not too sure whether you could normalise it further without over-doing it. Looks like you will need to perform a lot of table joins to "complete" your data, but any database with general normalisation will need to do this.

Out of interest, what did you use to create this schematic ? I've been looking for something that will generate database schematic diagrams but I've never managed to find anything that looks this good.

- Mike

[faragerri]

Thanks for your help.

I have used DBDesigner 4 wich is under GPL.

I hope that I will be able of coding that whole thing. Especially the part of the results will be quite difficult to do for me.