Sorry in advance for the verbose explanation but I don't know how else to explain things.
I'm sure there is a simple solution and I just cannot see it.
The database is designed to track information about turtles nests and the hatching of the eggs and figure averages of eggs per nest, survival rates, tempurature of the nests, tides, weather, moon phases etc. over time.
There is about 12 years of data that will be imported at some point from the XLS files where it is now being tracked.
The many to many relation ship I'm having a problem with is this:
A turtle lays a nest in a beach. These eggs are removed from the beach and taken to a nursery where they are placed in incubators.
The incubators hold 120 average sized eggs.
Each nests will have between and 45 and 150 eggs per nest, with anaverage of 100 eggs.
To maximize the use of space in the nursery and incubators the nests are combined to fill each incubator.
So far so good.(one incubator / multiple nests.)
The problem arises when there are more eggs in a nest, say 138 than will fit in the incubator. (one nest / multiple incubators.)
Once the eggs hatch, the incubators are cleaned and the live hatchlings, dead hatchlings that are inside as well as outside the shell and the empty shells are counted.
This is to correlate the number of nests and eggs to calculate the averages for:
1- eggs per nest
2- number of live hatchlings released
3- number of hatchlings dead in the incubator/nest but not in the shell
4- number of hatchlings dead but still in the shell
5- number of sterile / unformed
6- number of shells
7- survival rate.
any assistance will be appreciated.
thanks,
Dirk
I'm sure there is a simple solution and I just cannot see it.
The database is designed to track information about turtles nests and the hatching of the eggs and figure averages of eggs per nest, survival rates, tempurature of the nests, tides, weather, moon phases etc. over time.
There is about 12 years of data that will be imported at some point from the XLS files where it is now being tracked.
The many to many relation ship I'm having a problem with is this:
A turtle lays a nest in a beach. These eggs are removed from the beach and taken to a nursery where they are placed in incubators.
The incubators hold 120 average sized eggs.
Each nests will have between and 45 and 150 eggs per nest, with anaverage of 100 eggs.
To maximize the use of space in the nursery and incubators the nests are combined to fill each incubator.
So far so good.(one incubator / multiple nests.)
The problem arises when there are more eggs in a nest, say 138 than will fit in the incubator. (one nest / multiple incubators.)
Once the eggs hatch, the incubators are cleaned and the live hatchlings, dead hatchlings that are inside as well as outside the shell and the empty shells are counted.
This is to correlate the number of nests and eggs to calculate the averages for:
1- eggs per nest
2- number of live hatchlings released
3- number of hatchlings dead in the incubator/nest but not in the shell
4- number of hatchlings dead but still in the shell
5- number of sterile / unformed
6- number of shells
7- survival rate.
any assistance will be appreciated.
thanks,
Dirk
Comment