Re: [OT] Design Question : People getting married
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