Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Architectural Issues
Message
From
07/01/2000 17:41:58
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
 
 
To
07/01/2000 17:20:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00314788
Message ID:
00314800
Views:
27
>category, a subcategory, a sub-sub category, then classed 4 ways.
>attributes common to each level and, finally, attributes that will only be >needed with certain combinations of categories, subs, subs-subs and classes.

Are the sub- and sub-sub- categories exclusive or common across parent categories? The answer will greatly affect how you model the data.

Remember the Venn diagrams from math class? Conceptually, i'd think about each category as a set, and the shared attributes as a common subset. The problem is that you'll probably have so many categories and attributes that you'll need an incomprehensible hypercube to represent the whole mess.

What kind of queries will they be attempting?

One other point to ponder: Are we overthinking a simple solution?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform