[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