I am fairly new to databases, I have written a few queries but nothing too fancy.
I am looking to create a database of restaurants in my city and was wondering how to organize it. The fields I am thinking about are:
[Location] --> Should I have separate fields for [city, state, zip and street number]?
[Avg Entree Price]
[Features (kid friendly, wifi, etc)]
So each restaurant in my database would have those fields. Is this the correct way to do this?
I would envision a query like (pseudo code)
SELECT from restaurant where 'Avg entree price' = 10 & CUISINE=indial & DELIVERY=yes WHERE neighborhood = southside