View Single Post
  #8  
Old June 5th, 2010, 12:05 AM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default db design to calculate overlap in group membership in time

You posted your question in a newsgroup that supports the use of Microsoft
Access. MS Access is a relational database.

It all starts with the data.

It sounds like you want to use a spreadsheet instead (all the data in one
table). Have you looked into that option?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"EHobs via AccessMonster.com" u60556@uwe wrote in message
news:a90abc7ad3805@uwe...
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