Hi I am making a 'bookmarks' database and pretty much have it sussed using two tables but I know that it might be better to use three but can't grasp it.
Here are the tables:
links table
id|cat_id|title|url (PK=id, cat_id)
catagories table
cat_id|name|parent (PK=cat_id, name)
I was told that to allow duplicate catagories and still index the 'name' I'd need three tables. As you might see I'm a little lost so any help would be much appreciated.
Cheers
Nick
Here are the tables:
links table
id|cat_id|title|url (PK=id, cat_id)
catagories table
cat_id|name|parent (PK=cat_id, name)
I was told that to allow duplicate catagories and still index the 'name' I'd need three tables. As you might see I'm a little lost so any help would be much appreciated.
Cheers
Nick