Darren Dick
D.Dick at uws.edu.au
Mon May 2 09:29:46 CDT 2005
Hi Chris Many thanks - That does make sense and I have applied that logic to my table designs already Again - Many thanks Darren ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of Chris Foote (Spike) Sent: Mon 2/05/2005 11:26 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2003: Design Q Good questions Darren! The decider IMHO is items that are going to be unique to the individual. drivers licence, SocialSec. No,Medicare No, DoB are unique so should be in same table as person's name/s. Address/'phone number/mobile number may be "linked" to more than one person so probably should be in separate table. In addition, each person may have more than one address, or indeed 'phone number. I have a db that contains details of some University Students. This has "home" as well as "term-time" addresses. HTH Chris Foote - UK -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren Dick Sent: 02 May 2005 14:11 To: accessd at databaseadvisors.com Subject: [AccessD] A2003: Design Q Hello all Quick q about table design preferences (Membership dB) I am storing the Addresses in a seperate table from the Members Table and linking the two with the MemberID in the Address table as a Foreign key Just wondering how far I should go with this. Should I keep basic contact details such as phone, mobile, email etc in a seperate table linked with an FK? Should I keep special Identifiers such as drivers licence, SocialSec. No,Medicare No, DoB etc in another seperated table linked with an FK Should I keep a seperate table of Names eg FirstName, MiddleName, LastName etc sepaerated into another table I know there has been some discussion recently about this and I see some people on the list are storing addresses seperate from the 'host' table. Just wondering what is too far? EG Names, Contact Details, Identifiers etc Many thanks in advance Darren -- 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