You're really asking a database design question, and it can be answered 
only by asking more questions.

The first has to be how much do you know about relational databases? The 
basic theory on normalization, simple queries, etc., covers about 6~10 
pages. There are some very good tutorials on the 'Net; search on something 
like "SQL tutorial"

Here are a couple:

This deals with MySQL, and gets you to third normal form quite painlessly:

The next question is "What information do you want from the database?" 
Write out all the possible questions you will ask of your data. This will 
tell you what you need to include.

When you have this answered, along with some basic table design 
information, you're in a good position to answer your question. 
Unfortunately there is no canned answer.

Here are a few tips though:

For dates, MySQL has a very useful date format. Use it.

Most numbers don't have to be stored as a numeric data type, they are more 
usefully stored as character data. Examples would be phone numbers, street 

Numbers which represent quantities, and on which you will do work, 
multiplying, adding ,dividing, etc., should be stored with a numeric data 
type. Examples would be price, quantity, number_of_members.

MySQL provides an easily used auto-increment field which you can use for a 
unique primary key on each table. Use it.

I know this isn't what you wanted to hear, but I hope it is helpful. The 
important steps are to determine the possible combinations of data you want 
to retrieve, and to set up your tables so that you do not needlessly 
duplicate data, what is otherwise known as third normal form.

Will it be somewhat hard work? Yes, but you only have to do it once. I'd 
also recommend that once you have your "perfect" design, sit down with some 
people who are somewhat familiar with your problem and have them ask 
questions about what is stored and how it will be retrieved.

Have fun - Miles Thompson

At 06:18 PM 1/3/2002 -0500, Viper1 wrote:
>I am trying to use the phpmyadmin to create an online resume site. I have
>created a table and it seems to be fine but I need some more help on the
>next steps also how to test the database out. I started by making a table
>called resumes # of fields is 11 first field is name var is 20 and so on.
>Can someone please help? Thanks, very much appreciated.

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to