Categories and Sub Categories - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Categories and Sub Categories

Author

Topic

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2008-04-23 : 20:51:43

Hello,

I am working on a web site that makes documents available to students.
I am using tags to classify each document content.

So I have the following tables:
Documents, Tags, DocumentsTags

I also need to categorize the documents:

Subject
|---- Level
|----- Year

For example:

Document_1 - Math > University Level > Second Year

How can I create a table to create such classification?

Thank You,
Miguel

soorajtnpki
Posting Yak Master

231 Posts

Posted - 2008-04-24 : 03:07:03

Hi
Why cant u create 2 tables for level and year and using their id to
document table...

ok,
thanks...

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2008-04-24 : 06:36:54

Hi,

I also have a Subject table ...
And if in the future I will have more categories?
Then I will have to add more tables.
I am not sure that is the way to go.

I found the following approach?
http://www.sqllessons.com/categories.html

Did anyone ever used something like this?

Thanks,
Miguel

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources