Normalisation? Help please!!!!

Hello All,

I am currently desgining my final year project.
I am stuck, because am unsure how to normalise the following tables.
Your advice and comments are very much appreciated.

Thanks
Tala

Table Customer
customer#, c_firstname, c_lastname, postcode, address1, address2, e-mail, dateofbirth, prov_liceince.

Instructor Table
Instructor#, I_name, I_location, I_email.

package table
package#, no_hours, priceperhour, time


is the above tables right?
do I need to add anything else?

if I would like to do a history of each customer, where they choose the package, any ideas how I can do that?

does it need this sort of table? or is it just a query?

Request#, customer#, date_requested, package#.


Thanks again for all the help and advice.
e-mail me ur comments at: cassandrya@hotmail.com

Yes, you would need a table such as:

Request#, customer#, date_requested, package#

in order to tie the other tables together.

Without knowing your specific application it is really hard to help much furhter. I don't see how an Instructor table fits in with customers and packages...