Database design -

[Richard Gray]

The database will provide content management for an Intranet site.

On the site we have a number of articles which are categorised. Each categories can also have sub-categories.

The relationships would seem to be

Category---->Sub-Category----->Article

A category has one or mant sub-categories. A sub-category has one or many articles.

However some categories have articles but are no sub-categories.

Should I create a further relationship between Category and Article to cater for this instance or should their be a dummy category record in this instance?

[Michael Laro]

------------
Richard Gray at 12/13/00 3:47:54 AM

The database will provide content management for an Intranet site.

On the site we have a number of articles which are categorised. Each categories can also have sub-categories.

The relationships would seem to be

Category---->Sub-Category----->Article

A category has one or mant sub-categories. A sub-category has one or many articles.

However some categories have articles but are no sub-categories.

Should I create a further relationship between Category and Article to cater for this instance or should their be a dummy category record in this instance?

I would say create the relationship. You just need to think of what type you will need.

This sounds alot like a MCDBA test question.

I hope this helps.

Mike