View Single Post
  #7  
Old June 4th, 2010, 11:02 PM posted to microsoft.public.access.tablesdbdesign
EHobs via AccessMonster.com
external usenet poster
 
Posts: 3
Default db design to calculate overlap in group membership in time

Hi Steve & Jeff,

Thanks for your comments. I was actually planning something much simpler than
the several tables Steve posted - I am working with only one type of bird at
one specific location. I was thinking of having just a single table that I
can query. I could put the data in the following format

Date BirdID ArrivalTime DepartureTime

Any ideas on how to structure a query that will allow me to:

1) determine the total shared amount of time present for any 2 individuals
2) determine all of the individuals present at any one time point

Thanks again,

Liz

Steve wrote:
Hi Liz,

Give me your comments please to the following tables ....

TblBirdType
BirdTypeID
BirdType (Robin, Sparrow, Dove, etc)

TblColor
ColorID
Color (Black, Red, B;ue, etc)

TblBird
BirdID
BirdTypeID
ColorID
other fields to uniquely identify a bird

TblLocation
LocationID
LocationDescription
other fields to iniquely identify a location

TblGroup
GroupID
LocationID
DateGroupObserved

TblGroupComposition
GroupCompositionID
GroupID
BirdID
TimeBirdObserved
ArrivalDeparture

Steve


Hi Steve,

[quoted text clipped - 66 lines]

Liz


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201006/1