[AccessD] Design Question

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.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan
Carbonnell
Sent: Wednesday, February 07, 2007 7:40 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Design Question

On 2/6/07, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> Is this for data entry or retrieval, Bryan?  For Retrieval, a star

It's for both. That's the PITA part.

> schema will work.  Just create tables with all the shared foreign key 
> fields and slice and dice to taste. ;o}  Not efficient for data entry 
> but whizbang for retrieval.

By Star schema, I'm assuming that is something like JC described?

--
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!"
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com