Jump to content

DB Design question


webweever

Recommended Posts

I currently have a DB with 1 table that I'm storing links in. It has 5 fields (id, name, url, description and tag). I want to add the ability to create and edit categories and put the links into whatever category.

 

My question is do I create a table for each different category and how do I associate each link with a particular category?

 

Any help or insite will be greatly appreciated.

 

Link to comment
https://forums.phpfreaks.com/topic/81080-db-design-question/
Share on other sites

My question is do I create a table for each different category

No.

 

how do I associate each link with a particular category

Via normalization.

 

 

1) Normalization:

http://en.wikipedia.org/wiki/Database_normalization

http://databases.about.com/od/specificproducts/a/normalization.htm

 

2) Will these categories be nested?

http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

 

That may get you started.

Link to comment
https://forums.phpfreaks.com/topic/81080-db-design-question/#findComment-411422
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.