Job listings DB

Hi, I am designing a system for my company to get employee resumes via the Web, rather than paper. All resumes now go into a mySQL DB, which can be searched by HR (at least that's the theory :) Here are the scripts I will be writing. User pages ---- Listings Descriptions Application form Admin pages ----------- Add listing Edit listing Delete listing Search for matches --- Now, job description consists of: job code department desig location desc qualification contact posted on salary range (?) Application form consists of: personal information: job code and name first name last name age sex addr 1 addr 2 city state zip country email web site primary phone country code city code local area type - home/work/cell sec. phone SAA willing to relocate?? employment history (last 3 jobs) start end employer job title field of work responsibilities is current employer? skills skill name years of experience references contact person phone email additional info free-form field salary current monetary range current non-monetary benefits expected type of employment trainee freelance full-time would you like your resume to be shared with other departments? My questions: For job listings - how do I design the tables? Can I dump all job listings into a single table, and all applications/resumes into another one? Or should they be normalized? If normalized - how much? For example, in a listing, I have job code, department, location, salary range, etc. - should I have separate tables for each of these? Like jcode dept loc 1 213 2 2 77 3 where dept and loc are FKs to other tables? Or is this taking it too far? Same for application form. All this information that I am getting - should I put into a single table, or split across separate tables? I do plan to search by differenet criteria later. What about items in drop-downs? For example, if I have a drop-down for salary ranges or countries - should this information come from a table, or should I hard-code into the form itself? How do I make the decision as to which is appropriate? Any assistance much appreciated. TIA, Vikram -- Give a homeless man a bundle of firewood, and he'll be warm for one day. Douse him with a gallon of gasoline and set him on fire, and he'll be warm for the rest of his life!