Jim Dettman
jimdettman at earthlink.net
Mon Mar 10 16:52:00 CST 2003
Charlotte, << And we all know how closely theory matches reality. <vbg>> Yeah right, I mean heck everyone is using natural keys, right? ;) Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Monday, March 10, 2003 2:39 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] normalization question Yes, Martin. And we all know how closely theory matches reality. <vbg> Charlotte Foust -----Original Message----- From: Mwp.Reid at Queens-Belfast.AC.UK [mailto:Mwp.Reid at Queens-Belfast.AC.UK] Sent: Monday, March 10, 2003 10:34 AM To: accessd at databaseadvisors.com 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 > _______________________________________________ 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