Re: Database model - confusion

[Marc M]

Hi Roland,

Thanks for your reply!

Here's an example of some real possible data:

Say I have some products that are photographs, while others are illustrations.

When I'm adding a product to my database, I first need to select product type.

Next, I begin to select the category. These categories are type specific. It's almost as if type is a master category (although there is another piece of data that is dependent upon type - I'll get to that)


Photography:
>landscapes:
>>metropolitan
>>>skyscrapers
>>desert
>>>cacti

Also dependent upon photography would be file type:
.jpg
.tga
.tif
.psd etc.

Illustration:
>people
>>skateboarder
>>basketball player
>vehicle
>>racecar
>>sportscar

file type: again, dependent upon file type - illustration.
.ai
.cdr
.psd etc.

Now it's possible that a product could fit into two categories, so I'd like to make sure that I'm set up for that potential for future growth.

Hopefully that will clear up my goal a bit.

Thanks for reading,
Marc

------------------------
Inner space - what a trip.