• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: [OT] Design Question : People getting married
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [OT] Design Question : People getting married


  • Subject: Re: [OT] Design Question : People getting married
  • From: Mark Morris <email@hidden>
  • Date: Thu, 24 Feb 2005 08:25:21 -0600

If this is the only purpose of knowing what the last name was historically, you could just have a field in the Publication table meaning "display name as of publication date". There would still be a one-to-many from Person to Publication, so the current name would always be available.

Your LastName table (or perhaps HistoricalName or something that allows any name change) would be more flexible but more complicated, so you have to decide how useful it would be for you and how much extra effort the flexibility's worth. :-)

Regards,
Mark

On Feb 23, 2005, at 9:54 PM, Owen McKerrow wrote:

Hi All,

Im currently creating a website which records and reports on Publications, such as Books, Journal Articles etc.

Now each publication is linked to a number of members who are considered to be the authors of this publication.

As an exmaple heres a book by Mary Jane.

Jane, M. A House on the Hill, Pengiun Books, Syndey 2001

Now Mary goes and gets herself hitched, and her last name changes to Smith

So now when we look at the book it looks like :

Smith, M. A House on the Hill, Penguin Books, Sydney 2001


However this is incorrect, all those books out there in the world aren't going to magically update there authors to Smith instead of Jane.


So my question is has anyone else had a similar problem and how have they dealt with it ?

My only though is that a Member has a to-Many relationship with a table called LastName, which records the last name and a date. So when Mary Jane changes to Mary Smith she gets a new entry in this table with her marriage date in it ( say 24/02/05, thats the 24th of Fuburary for all our American cousins : )

So then when every Im showing a publications I need to check the publications publishing date and work out which last name was being used at that time.

This seems a little complicated, is there a better way ?


Owen McKerrow WebMaster, emlab http://emlab.uow.edu.au

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
'The test of a first-rate intelligence is the ability to hold two opposed ideas in the mind at the same time and still be able to function.'
-F.Scott Fitzgerald,


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden


This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: [OT] Design Question : People getting married
      • From: Mark Morris <email@hidden>
References: 
 >[OT] Design Question : People getting married (From: Owen McKerrow <email@hidden>)

  • Prev by Date: Re: Using the WSMakeStub tool
  • Next by Date: Re: [OT] Design Question : People getting married
  • Previous by thread: Re: [OT] Design Question : People getting married
  • Next by thread: Re: [OT] Design Question : People getting married
  • Index(es):
    • Date
    • Thread