> You mean you have one resource which relates a resource to an activity > and has a score and an application? > > Could you elaborate, please?
In essence, the relation is (resource, application, activity)* and has a score. (*in terms of relational dbs this would be a primary key) This allows making summarized (resource, app) and (resource, activity) and (resource) queries. Cheers -- I don't really trust a sane person. -- Lyle Alzado