[AccessD] A2003: Design Q

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




More information about the AccessD mailing list