Hello

I want to convert a paper form to a database. i did it but i'm not sure... so help me please.

the paper form contain 4 sections: Personal information, University Degree information, Job information and certifications list.

This is the field on the Paper:
First name, Last name, ID, Date of birth, city,
Degree level, Degree date, University, section,
Jop name, Hire date, department, Jop Location,
certification name, certification date, certification period, Authored by

I think the City field need to be in a new table, because the city repeated frequently. i also made a new tables for Degree level, University, section, department, Jop Location And certification.

Please correct me.

Thanks

If you've made the tables, post them here so we're not guessing.

OK,
This is the form:
http://i50.tinypic.com/b487qq.jpg

This is the tables i made:
http://i50.tinypic.com/35i3bdk.jpg

Should i make a new tables for: DEGREE.Grade, DEGREE.Major field of study, DEGREE.College Name, Certifications.Institution, JOP.Location, JOP.Standing and JOP.Current Position?

Please correct me.

This is fields names (in case you want to copy/past):

National ID:
First Name:
Middle Name:
Last Name:
Date of Birth:
Sex:
License Number:
City of issue:
Date of issue:
Expiration date:
Home Address:
Postal Code:
Email
Phone Number

Current degree:
Date Obtained:
Grade:
Major field of study:
College Name:

Jop Title:
Date Employed:
Jop Location:
Jop Standing:
Current Position:

Certification Obtained
Period
Date Attended
Institution

Looks OK to me, but if you make City a separate table rather than a free-text field, be prepared to populate the table with a list of every single city you will encounter. Be sure this separation of data is necessary for your requirements.

How could i make sure? is there any rules about this?

The CITY field is not important for me, i will not make a quiry depend on it.

I will quiry only by: Names, National ID, Jop Title, Jop Location, Jop Standing and Current Position.

Thanks for your reply.

Then don't bother creating a separate table for cities.