|
| |
|
|
zappastixs
Posts: 4
Joined: 8/19/2003
Status: offline
 |
Help with Tables - 8/20/2003 10:06:01
Hi
Advice please on the best way to set up a 'Web Directory'
using Access 2000 (via FrontPage 2000).
If I can get the project off the ground, it would eventually
have hundreds of 'categories'
This directory would search on standard links to categories
but at the same time provide users a search facility using
the keywords that web site owners have included in their
submission (I know it's been done before).
I worked out what I think would be the best way but this is
my first project of this kind and I would prefer to know if
you think I will run into problems further down the line.
This is what I was thinking of doing for the table layout
Under a main category for MUSIC – I have 3 Sub Categories
Songwriters – Pop – Rock
I have 3 Tables questions;
1) does the following layout look like it will work?
2) when a user submits data from ONE web form does Access
know where to place the data into the individual tables.
3) if a user were to search on just 'keywords' (KEYWORDS_tbl)
and a keyword matched a sub category (i.e. SONGWRITERS) would
the Web Address of that particular site(s) be displayed.
SONGWRITERS_tbl
Web_address_ID (key)
ROCK_tbl
Web_address_ID (key)
POP_tbl
Web_address_ID (key)
KEYWORDS_tbl
Keywords_ID (key)
Web_address_ID
SITE_DESCRIPTION_tbl
Site_description (key)
Web_address_ID
I hope I have made sense - I confuse myself sometimes.
Thank you in advance, Stephen
_____________________________
|
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Help with Tables - 8/20/2003 11:51:41
If it were me and that was all the info I was using, why couldn't you put the category types into 1 table and use the category ID in the site description? It looks to me like you possibly could put your keyword list in there as well. Unless you have a ton of keywords that should be adequate.
I would even suggest maybe just 1 table to keep it simple. If you only have 3 categories, why couldn't you just use 1,2, or 3 in a column in the original table.
If you did that, maybe questions 2 & 3 are moot?
Or maybe I'm missing a bunch of stuff here?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
zappastixs
Posts: 4
Joined: 8/19/2003
Status: offline
|
RE: Help with Tables - 8/20/2003 13:28:09
Thanks - I thought of that.
What stopped me is that if there
are say 1,000 categories and a
user selects the last category
wouldn't that slow the results
being delivered.
I'm just thinking out loud here
'cause I don't know if that would
happen or not.
If that were the case - would
indexing the Category help?
Thanks again - Stephen
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Help with Tables - 8/20/2003 13:51:05
Ooops! Missed that about "100's" of categories. But I'm still unsure as to why you'd make a table for each category. How 'bout 2 tables?
I would also question the idea of 1000 categories. It sounds like you want them in a drop down menu? IMO that's a bad idea - takes too long to build the page.
Sorry, without knowing all the details, its difficult to design a DB scheme. Have you normalized your DB design? Don't want to insult your intelligence, but if you're not familiar with DB "normalization", you may want to take a look at this:
http://www.devshed.com/Server_Side/MySQL/Normal/Normal1/page3.html
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
