[OT] Design Question : People getting married
[OT] Design Question : People getting married
- Subject: [OT] Design Question : People getting married
- From: Owen McKerrow <email@hidden>
- Date: Thu, 24 Feb 2005 14:54:21 +1100
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:
This email sent to email@hidden