[thelist] Database Design help

Kath kath at cyber-kat.com
Sun Apr 3 11:19:51 CDT 2005


If I recall correctly, we have some database gurus on the list.  I'm hoping 
that you can help with a design dilemma I have.

I'm a database newbie attempting to design a database that will hold the 
restaurant info on this site - http://www.gemsguides.com/

So far I have 4 tables:
Restaurants with RestID (key) RestName, RestAddress, City, RestPhone and 
CuisineType fields
Cities with CityID, CityName, CityAbrev, ColorCode fields
CuisineType with CuisineID and cuisineType
Service Key with ServiceID, City (because of the color coding), ServiceType 
and iconURL

As you can see from the site (which is static right now) each restaurant is 
color-coded by city, listed by Cuisine Type and each has icons for the 
services offered.

I'm stuck on how to get the services tied into the Restaurants and in the 
correct color key.

My client only has a few restaurants contracted for the initial issue of 
their guide, but they hope to add many more.  I thought the best way to 
keep track and organize them would be in a database.  This will allow me to 
do dynamic pages that could be sorted by cuisine, location or service type.

I started a table - Restaurant Services with Restaurant names and service 
types, but I'm unsure of how to proceed to connect the two and get them 
color coded correctly.  Can anyone help?

I'm doing my basic design in Access because I find it easier to "think" in 
Access terms, but I plan on converting it to MySQL once the design is set.

TIA

Kath ...
Established 1995 --> www.cyber-kat.com
"The greatest of faults, I should say, is to be conscious of none." -Thomas
Carlyle, writer (1795-1881) 




More information about the thelist mailing list