[AccessD] Design Question

On 2/7/07, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> I just skimmed John's reply, but no, that isn't exactly it.  A star
> schema is commonly used in data warehousing and tables have a
> multiplicity of FKs for all tables they relate to.  That makes querying
> data a snap because you don't need complicated joins to get the data you
> want, just filter on the FKs.

So in the people table there would be columns for the FKs for
Software, Hardware, Service  Agreements and Facilities. The equipment
table would have a column for the others, etc?

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"