[AccessD] normalization question

Mwp.Reid at Queens-Belfast.AC.UK Mwp.Reid at Queens-Belfast.AC.UK
Mon Mar 10 14:19:16 CST 2003


In the design you include the FKs. Matter of course. Least I do. Particulary if 
your using a case tool to do the ERs etc.

Martin


Quoting Susan Harkins <harkins at iglou.com>:

> I agree with your Charles. It's the smart developer that can jump right
> in
> and create those tables with little or no thought to design before
> starting.
> I wouldn't attempt it.
> 
> I'm just curious about the foreign keys though at this point -- more so
> than
> the actual design process.
> 
> For whatever reason, I seem to remove fields until all my tables are
> set.
> Then, I go back and relate the tables by inserting foreign keys, and
> I'm
> just curious what others do.
> 
> Susan H.
> 
> 
> > Susan,
> >
> > Whether you do it on paper or on the PC, it usually is an iterative
> > process, at least in my experience.  By that I mean as you go along
> you
> > will discover that one or more of the tables you have already
> designed
> > needs to be split since some of the data fields apply only to the
> > subject of the table while other data fields does not.  And you will
> > notice that some data fields split over several tables should be
> > combined into one table.
> >
> > It would be a very simple application, or a very astute individual,
> > where all the relationships are obvious from the beginning.
> >
> > Charles Wortz
> > Software Development Division
> > Texas Education Agency
> > 1701 N. Congress Ave
> > Austin, TX 78701-1494
> > 512-463-9493
> > CWortz at tea.state.tx.us
> >
> >
> >
> > -----Original Message-----
> > From: Susan Harkins [mailto:harkins at iglou.com]
> > Sent: Monday 2003 Mar 10 12:50
> > To: accessd at databaseadvisors.com
> > Subject: Re: [AccessD] normalization question
> >
> > Yes, I agree...
> >
> > but in the process of making your paper lists -- when?
> >
> >
> > ----- Original Message -----
> > From: <Mwp.Reid at Queens-Belfast.AC.UK>
> > To: <accessd at databaseadvisors.com>
> > Sent: Monday, March 10, 2003 1:34 PM
> > Subject: RE: [AccessD] normalization question
> >
> >
> > >
> > > you do it before turning the PC on when your designing the
> structures.
> >
> > > The theory is that the data is normalised before you actually
> create
> > > the
> > tables
> > > physically.
> > >
> > > Martin
> > >
> > > (<:
> > >
> > >
> > >
> > > Quoting Charlotte Foust <cfoust at infostatsystems.com>:
> > >
> > > > I tend to do it at the time so I don't forget.  Of course, as we
> get
> >
> > > > older our memory ... Uh, what was I saying?  <vbg>
> > > >
> > > > Charlotte Foust
> > > >
> > > > -----Original Message-----
> > > > From: Susan Harkins [mailto:harkins at iglou.com]
> > > > Sent: Sunday, March 09, 2003 3:36 PM
> > > > To: AccessD at databaseadvisors.com
> > > > Subject: [AccessD] normalization question
> > > >
> > > >
> > > > When you remove a field to another table (for whatever reason),
> do
> > > > you immediately create the foreign key in the original table, or
> do
> > > > you wait until you've completely normalized each table and then
> > > > return to the tables and insert all the foreign keys then?
> > > >
> > > > I tend to do it later because the nature of a single field can
> > > > change.
> > > >
> > > > Does anyone know if the relational model requires a particular
> > > > routine?
> > > >
> > > > Just curious.
> > > >
> > > > Susan H.
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



More information about the AccessD mailing list