Re: Portal Database design help
according to what i understand from your suggestions i had designed the database like this..
Categories table
category_id | category_name
States table
state_id | state_name
Cities table
city_id | city_name | state id
Companies table
company_id | company_name | add1 | add2 | add3 | add4 | pin | city_id
contact_numbers table
company_id | phone1 | phone2 | mobile1 | mobile2 | fax1 | fax2
email_websites table
company_id | email1 | email2 | website1 | website2
contact_person table
company_id | contactperson1 | designation | contactperson2 | designation
business_details table
company_id | business_details
status tables
company_id | status(either 1 or 2, as this is going to specify, is it a paid or unpaid listing in my database)
categories_companies_relation table
category_id | company_id
IS THIS A NORMALIZED DATABASE OR NEEDS MORE MODIFICATIONS.
Subject
Written By
Posted
Re: Portal Database design help
April 30, 2009 04:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.