vanekerenam
Registered User.
- Local time
- Yesterday, 20:58
- Joined
- Dec 27, 2016
- Messages
- 11
Hello everyone,
for a little exercise I've been asked to make a small 'fake' database (only design tables + create relationships) that 'could have been used' for a certain paper.
It would be amazing if some of you could have a look and then get back to me whether my database is well-designed, and where I could have made errors, and perhaps where there are improvements possible.
Here is the link to my database:
fast-files.com/getfile.aspx?file=129366
Below I'll give the info I can work with to make the database:
it's about the monitoring of populations of two species of albatross at different locations. They did this by counting nests containing one or more eggs, banding juveniles and adults, and by counting recaptured banded birds.
"Monitoring of the wandering albatross population was
carried out on Possession Island, one of the
Crozet islands in the southwestern Indian Ocean (Fig. 1),
between 1960 and 1995. The entire population of Possession
Island was censused seven times between 1960
and 1980, and every year since 1981. Three colonies are
found on the island, at Baie du Marin, Est and Pointe
Basse (Weimerskirch & Jouventin, 1987, for location).
The number of nests with an egg was recorded when all
laying had been completed, i.e. around 15 January every
year. A total of 3312 adult birds and 4750 chicks prior
to fledging were banded with monel bands between 1960
and 1994. Since 1966, recapture of banded birds has
been undertaken each year between December and
April. Bands of breeding birds were checked after egglaying
until April, bands of non-breeders between
December and April. At Kerguelen, wandering albatrosses
were censused in mid-January on the Courbet
Peninsula in 1971 and between 1985 and 1993 (see
Weimerskirch et al., 1989a). The small Amsterdam
albatross population was censused on Amsterdam
Island every year between 1983 and 1994, and breeding
success was determined from monthly checks of nests
from egg-laying in March until fledging the following
January. Since 1983, all chicks have been banded with
monel and plastic bands prior to fledging; recording of
banded birds is carried out each year between March
and May.
" (Weimerskirch, Brothers and Jouventin, 1997)
Thank you very much in advance!
for a little exercise I've been asked to make a small 'fake' database (only design tables + create relationships) that 'could have been used' for a certain paper.
It would be amazing if some of you could have a look and then get back to me whether my database is well-designed, and where I could have made errors, and perhaps where there are improvements possible.
Here is the link to my database:
fast-files.com/getfile.aspx?file=129366
Below I'll give the info I can work with to make the database:
it's about the monitoring of populations of two species of albatross at different locations. They did this by counting nests containing one or more eggs, banding juveniles and adults, and by counting recaptured banded birds.
"Monitoring of the wandering albatross population was
carried out on Possession Island, one of the
Crozet islands in the southwestern Indian Ocean (Fig. 1),
between 1960 and 1995. The entire population of Possession
Island was censused seven times between 1960
and 1980, and every year since 1981. Three colonies are
found on the island, at Baie du Marin, Est and Pointe
Basse (Weimerskirch & Jouventin, 1987, for location).
The number of nests with an egg was recorded when all
laying had been completed, i.e. around 15 January every
year. A total of 3312 adult birds and 4750 chicks prior
to fledging were banded with monel bands between 1960
and 1994. Since 1966, recapture of banded birds has
been undertaken each year between December and
April. Bands of breeding birds were checked after egglaying
until April, bands of non-breeders between
December and April. At Kerguelen, wandering albatrosses
were censused in mid-January on the Courbet
Peninsula in 1971 and between 1985 and 1993 (see
Weimerskirch et al., 1989a). The small Amsterdam
albatross population was censused on Amsterdam
Island every year between 1983 and 1994, and breeding
success was determined from monthly checks of nests
from egg-laying in March until fledging the following
January. Since 1983, all chicks have been banded with
monel and plastic bands prior to fledging; recording of
banded birds is carried out each year between March
and May.
" (Weimerskirch, Brothers and Jouventin, 1997)
Thank you very much in advance!