How to setup MySql Restaurant d/b schema

[Bret McIvor]

I'm a novice with MySql - needing to know how to setup the schema for a 'restaurant guide' website. Here is the search argument:

-----------------------------------------
I want a ($$$,$$,$) restaurant
in (city or state)
serving (american, mexican, etc) cuisine
and is (quiet, busy)
-----------------------------------------

How many tables would you recommend? Is Netbeans a worthwhile tool? Restaurants will be optionally able to upload a menu, choose hours of operation, parking (yes, no) etc like Yelp's parameters. There will be Google map integration and I want to eventually move this all over to a mobile app. Finally, do you know where I can get an existing populated d/b of US rest. names free?
Thanks a bunch. Bret

[JKing]

You would want a main restaurant table. In this it would store the information about each restaurant. For best practices you will want to separate information like states, cities into their own tables and only store the id as a foreign key in the restaurant table.

Sounds like you have a large project ahead of you. If you are struggling with the database side of things you may want to think about outsourcing it.

[bmcivor]

Thanks JKing for your reply.

You say to create the following tables:
CITY
STATE

OK!

Do these categories need to be in separate tables also?
CUISINE
$, $$, $$$
QUIET
BUSY

Thanks

[JKing]

Cuisine is something I would put into a separate table as there will many different values.

I would use an enum data type for the quiet/busy field.

Not sure what the $$ fields are supposed to represent?

[Bret McIvor]

Thanks JKing. The $$ fields are cheap, moderate, expensive, hence $, $$, $$$.