langenf Posted April 20, 2010 Share Posted April 20, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/199114-database-design-for-a-simple-site/ Share on other sites More sharing options...
ignace Posted April 20, 2010 Share Posted April 20, 2010 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) Quote Link to comment https://forums.phpfreaks.com/topic/199114-database-design-for-a-simple-site/#findComment-1045118 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.