I am a bit confused of deciding the relationship between entities in an information system when taking the time factor into consideration. Can someone clarify this for me please.


Example

book and borrower in a library

At a particular time instant, definitely the relationship between borrower and book is 1 : Many as one borrower can borrow many books but one book cannot be borrowed by many borrowers

Over a period of time, the relationship will be Many : Many as one borrower can have borrowed many books and one book have been borrowed by many borrowers too.


Student and locker in a school

At a particular time instant, definitely the relationship between student and locker is 1 : 1 as one student will be given one locker to use

Over a period of time, the relationship will be Many : Many as one stduent can have used many lockers and one locker had been used by many students too.

By mail-merge photo on Monday, October 04, 2004 - 10:12 am:

I like to do a mail merge between

MS-ACCESS 2000 and MS-Word 2000 to

mail - merge (generate) Identity cards for staff.


The fields included:

surname, name, photo


Can someone tell me how to do it?


Thanks

By Craig on Tuesday, February 22, 2005 - 08:52 am:

Student and locker in a school

At a particular time instant, definitely the relationship between student and locker is 1 : 1 as one student will be given one locker to use

Over a period of time, the relationship will be Many : Many as one stduent can have used many lockers and one locker had been used by many students too.

This will be a MANY :: MANY with an interim table containing a time/date. A student can only have 1 locker at a time, and a locker can only have 1 student at a time.

Same with the first one