✅ 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?
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?
