Is there any tool/SW to help me build a good database?

[boyhcm]

I am new to databases. I have a classifieds website with MySQL db and I am soon about to use SOLR to index them also. Then whenever a query is done, SOLR will return ID:s and I will match those ID:s to the MySQL database and fetch the ads to display.Anyways, I have trouble making the db.Users may choose from a drop-list what category to search. Lets say they choose CARS. Then a div is shown containing drop lists for "YEAR, FUEL, GEARBOX, PRICE". Then they may choose LOCATION also. Also if they wish, they may type in a querystring. All is optional though. How should I setup this?For example, I have this below for CARS right now, and I have to make fields/tables for Motorcycles, trucks, scooters also... But so far I have got only for the CARS.How would you do the structuring and designing?I am thinking about doing one of these for each category (TRUCKS, MC, HOUSES etc).SORRY, but I can't get the tabs to work here, could anybody edit this so it looks "more readable" please!\[code\]F?lt Typ Null Standard <br>id int(7) Nej ad_id varchar(62) Nej area varchar(40) Nej area_community varchar(50) Nej price int(9) Nej year int(4) Nej mileage int(6) Nej gearbox varchar(12) Nej fuel varchar(12) Nej insert_date timestamp Nej CURRENT_TIMESTAMPposter_name varchar(40) Nej poster_email varchar(50) Nej poster_tel varchar(20) Nej poster_password varchar(15) Nej headline varchar(40) Nej description text Nej salebuy varchar(7) Nej total_pics int(2) Nej changeable int(1) Nej hide_tel int(1) Nej ad_category varchar(60) Nej \[/code\]Thanks and if you need more input just let me know and I will update this Q.