Re: [OT] Design Question : People getting married
Re: [OT] Design Question : People getting married
- Subject: Re: [OT] Design Question : People getting married
- From: Ken Anderson <email@hidden>
- Date: Wed, 23 Feb 2005 22:56:57 -0500
Owen,
Why not have an entity that sits inbetween the Person and the
Publication? Maybe call it Alias or Representation. So you could
have:
Person <-->> Alias <-- Publication
This way, you could handle name differences including ghost writers,
etc. The Publication would always point to the same alias, and that
alias, to a person.
Ken
On Feb 23, 2005, at 10: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