i am developing a website for business search engine.... when one can search any kind of business..... how to design the database especially the 1) business listings and 2) keywords... (on which thees business listings will show up) how to arrange these two...in the most suitable and fast manner...
Try this structure: business: id name etc... keyword: id keyword busness_keyword id business_id keyword_id