ā Zoo database design
ive got quite a lengthy problem xd
i dunno if anyone will be bothered to answer but im kind of stuck
ill post it anyways
so as you can see they want us to design a database for a zoo
the zoo has provided a flat file DB for the animals and handlers
so i begin to go through the process of normalization
1NF
2NF
3NF
and this is where i get stuck, there does not seem to be any transitive dependencies in these tables though i know that the DB can be split further into more relations i might be asking for a lot but if anyone could point me to something i might have done wrong here i would greatly appreciate it.
P.S.
perhaps in the 2NF for the handlers table there should be another composite key??? might this be the answer to my suffering?
and this is where i get stuck, there does not seem to be any transitive dependencies in these tables though i know that the DB can be split further into more relations i might be asking for a lot but if anyone could point me to something i might have done wrong here i would greatly appreciate it.
P.S.
perhaps in the 2NF for the handlers table there should be another composite key??? might this be the answer to my suffering?
11 Replies
what's the actual question here? It's a bit vague to scan the whole thing if I'm honest.
looks to me to be 3 tables, KISS
Animals, Handlers, HandlerAnimalFeedingSchedules
so im suposed to normalize the tables down to the 3rd Normal form
its just about the design
im meant to go through 1 Remove multivalued types 2 Remove partial dependencies 3 Remove transitive dependencies
yea its a school
I don't think I'd make it that complicated.
what are you getting graded on?
well its a resubmission so it will be capped at pass
either way
but
if i dont normalize this
then ill mess up my next assignment which is the implementation
the teacher has given me a database to use for the implementation which looks like this
but i hardly want to use his idea
and not understand the concept fully
i think the issue might be that
i should have used the composite key in the handlers table
being the first name and specialism
i dunno man this whole assignment just sucked the soul out of me man
I think it's 3 tables, personally.
you're doing this in C#?
no this is in Access DB
i know this is a C# server but i thought id shoot my shot anyway
š
meh anyways š
ill keep trying
I mean it's fine
I would just keep it at 3 tables, personally, unless animals can share enclosures?
no the issue here is that it cannot stay in 3 tables because it has to be split down further so that the zoo can produce reports
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.