Database design for a simple site

[langenf]

Please let me introduce my weakness right away. I suck in database design since im largely a self learned coder. They have given me a couple of pages and asked me to program them. The most important among them is a form used to enter information http://img402.imageshack.us/img402/2549/screenshoton.jpg  Industry in question is tourism.

 

The table called user master has login information choosing and username, password , email (a different one shown in this screenshot). Kindly note that i have not included tables similar to Destinations  ( country, businesscode,segment and jobarea) in this ERD. Kindly give me a few suggestions. I am willing to completely redesign this database if this design is too bad. Please have a look at http://img694.imageshack.us/img694/2725/erd.gif

 

[ignace]

You are over complicating it:

 

companies (id, category_id, segment_id, name, description, website_address)

companies_addresses (id, company_id, country_id, address, city, postal_code, province)

companies_contacts (id, company_id, job_area_id, title, fname, mname, lname, email_address, phone)

companies_destinations (company_id, destination_id)
companies_business_codes (company_id, business_code_id)

destinations (id, destination)
business_codes (id, business_code)
jobs_areas (id, job_area)
countries (id, country)