Could use help designing small database :)

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!
 
Well it should be accessible if you put www(dot) in front of it.
could also try 321webs.com/download/129366.htm

The answer to your latter question is affirmative!
 
try to put www (dot) in front, that might help , if not
321webs.com/download/129366.htm

answer to the last question is yes :)
 
I definitely smell homework.

Ironically, I was just thinking today about how it had been a while since I'd seen a 'please fix my homework' post here.
 
Well I'm not looking for someone to do my homework for me, I'm just asking for someone to check it and perhaps give me some advice. Don't know why it wouldn't be allowed to ask for help with your education and it would be allowed to ask for help with your job.
 
Most of us are unwilling to download files from third-party sources. Follow the instructions on jdraw's post to put up a zipped copy of your database and someone will probably take a look at it. (I won't be able to because I'll be at work, and won't be able to download things there.)

People check to see if it's homework because we tend to treat homework differently - instead of just giving answers, we tend to point people in the direction to figure it out themselves unless those answers are unusually esoteric.

Also, THIS link is something you should probably read for future posting.
 
I have reduced the question to the basic elements I would consider relivant to dB design:-

monitoring of pop of two species of albatross

different locations

counting nests containing one or more eggs

banding juveniles and adults

counting recaptured banded birds.

wandering albatross
on Possession Island censused yearly

colonies
Baie du Marin
Est
Pointe

nests with eggs recorded

3312 adult birds
4750 chicks
fledgings banded

Recapture each year
breeding birds recorded
non-breeders recorded

wandering albatrosses
Courbet Peninsula

Amsterdam
albatross

Amsterdam
monthly checks
chicks banded

Questions
What is a location, an island or a colony?

Is Courbet Peninsula a colony?

It's not clear if the Amsterdam island only has Amsterdam species.

Does Amsterdam only have monthly counts?

Wandering albatross appears to have starting values:-
3312 adult birds
4750 chicks

Can starting values be determined for the other species?

Sent from my SM-G925F using Tapatalk
 
Thank you so much for your help,

It is indeed a bit confusing,

Overall there are indeed 5 sampling stations (or if you will, colonies):
Amsterdam island (indeed, only amsterdamensis lives there)
Possession Island, which is one of the Crozet island, has three sampling stations (Est, Point Basse, Baie du Marin),
the last station is on the island called Kerguelen, more specifically on the Courbet peninsula.

Overall, I think the gist of it is just that there are 5 sampling stations, whether these are located on larger islands (one of the Crozet islands,...) is just extra information that not need to be included. For example, I have called one of the stations Kerguelen, because the Courbet peninsula is the only station on that island anyways, on Possession Island more distinctions needed to be made because it has 3 stations.

Amsterdam indeed only seems to have monthly counts.

there is not much detailed info , so I'm afraid I can't acquire starting values for the other species that are not given in the text provided.
 
Is the purpose of the dB to record historic information, or is it to be used for managing future census data?

Sent from my SM-G925F using Tapatalk
 
The aim is to simulate a dB that could be the one these researchers used during this project, which nicely relates all data to each other that they collected (even though some information might not be in the text provided). Hence the databse i had so far with 5 tables)
 
What happens if a pocket of one species is discovered in the colony of another species?

Sent from my SM-G925F using Tapatalk
 
The dB i have to develop only incorporates things that have happened until the point this paper was published, the dB might need to be tweaked if this'd happen, but since it is not included in the text I was provided with it's "not my concern" ;)
 
Well, specifics will depend on how your teacher/professor handles going above-and-beyond, but in the real world, it's important to future-proof a db as much as possible, as long as it doesn't put you over budget or cause delays (and sometimes even then).

The rule of thumb is that if there is a possible situation that can screw up your database, then it WILL happen, and it needs to be accounted for. If you don't do it during design, then you will absolutely be doing it after release, and that is almost always more difficult.

That said, we're aware classroom environments tend to be a little more limited in scope, and some professors/teachers really dislike people going beyond the designated limits of the project.

Some bosses too, for that matter. :(
 
Do the "bands" have individual unique ID's?

Sent from my SM-G925F using Tapatalk
 
To define the actual census point, I am thinking this is better defined as an annual event, not a period or specific date.

For example, if a census started in December 2016 and finished in march 2017 you would record it as the "2016" census.

I think the reference to monthly checks is a red herring. They are details of the census process, not census points.

Sent from my SM-G925F using Tapatalk
 
Is it best to think in terms of one census per year for both species? Or would it be better to think in terms of two censuses (should that be censi) one for each species?

Sent from my SM-G925F using Tapatalk
 
should that be censi

'Censuses' in English, based on both my own experience and everything I could look up. (I checked because I got burned not too long ago on 'temperament' - the 'a' isn't pronounced in the Great Lakes accent, so I didn't even realize it was there!)

It DOES seem kind of random when we use the Latin pluralization (which AWF doesn't consider to be a word, it seems), and when we go with the English rules. In this case I think it's because it's a created meaning attached to what was originally the past participle of 'censere', which means 'to assess'. Apparently English rules apply because it wasn't a noun in Latin.

/derail
 
Gizmo, thank you so much for the help you've been already,

I think that, because this is an assignment to make us familiar with databases, I should not worry about how to treat the collected data to make them fit into a database.
All that has been asked of me is to make a dummy dB that the researchers of this project could have used (even if it's oversimplified), hence I linked the dB I made to see whether people here thought it made sense a bit, or whether there are mistakes in the relationships, things incorrect in the tables etc...

Thanks!
 

Users who are viewing this thread

Back
Top Bottom