Web Hosting Talk







View Full Version : Question about planning a mysql database


Suedish
03-07-2004, 04:19 PM
Hi.
I have a question about how to make the databases in mysql, i dont mean the actual code, just how it would be done in theory. I'm still quite new to programming in php and sql as you will notice.

I have a project now where people can register themselves with their info, and the name of their team.
This is going to be a very very simple football (pure text) game where each member has their own team with a couple of players in it.

I'm wondering how i should make the database with the players in it.

The info on each player would be something like:
Name, Age, Skill in passing, Skill in shooting, Running speed, Skill in defending.
Should i make a table called something like "players" and then for each player i add it's values? For example (John Doe, 23, 2, 4, 10, 2)

Is that the way to do it? Sorry if the question seems a bit "fuzzy" but i hope you still understand what i mean.

Thank you very much in advance.

cleaver
03-07-2004, 04:47 PM
That sounds about right.

If you want to go deeper in the future, I suggest learning about database normalization.

cleaver
03-07-2004, 04:48 PM
Here's an article about normalization...

See: http://support.microsoft.com/support/kb/articles/Q100/1/39.ASP

(brief into... there's lots more out there.)