Self-paced

Explore our extensive collection of courses designed to help you master various subjects and skills. Whether you're a beginner or an advanced learner, there's something here for everyone.

Bootcamp

Learn live

Join us for our free workshops, webinars, and other events to learn more about our programs and get started on your journey to becoming a developer.

Upcoming live events

Learning library

For all the self-taught geeks out there, here is our content library with most of the learning materials we have produced throughout the years.

It makes sense to start learning by reading and watching videos about fundamentals and how things work.

Search from all Lessons


LoginGet Started

Register to 4Geeks

← Back to Projects

Modeling a Zoo database

Difficulty

  • intermediate

Average duration

1 hrs

Technologies

  • sql

  • postgres

  • database

  • modeling

Difficulty

  • intermediate

Average duration

1 hrs

Technologies

  • sql

  • postgres

  • database

  • modeling

How to start?

Log on to quickdatabasediagrams.com and create a new diagram. Then you can start creating your model and share it later.

📝Instructions

Build a database model that responds to the requirements stated in the following paragraph.

  • You want to design a relational database that stores information about the world's zoos and the animal species they house.
  • For each zoo we know the name, city and country where it is located, size (in m2) and annual budget.
  • For each animal we want to store the species, the common name, scientific name, the genus, the family to which it belongs and whether it is in danger of extinction or not.
  • The relationship between species, genus, and family is hierarchical and reflects the evolutionary relationships among organisms. Here’s an overview of each level and their relationships:
  • Family: Felidae (Cat family)
    • Genus: Panthera
      • Species: Panthera leo (Lion)
      • Species: Panthera tigris (Tiger)
    • Genus: Felis
      • Species: Felis catus (Domestic Cat)
      • Species: Felis silvestris (Wildcat)
  • You should store information about each animal specimen that the zoos are hosting, such as: Identification number, corresponding species, genus, sex, year of birth, country of origin and continent.
  • A single species cannot be classified into two different families or genus at the same time.
  • The number of animal families is subject to change as new discoveries are made. As of recent estimates, there are approximately 1,200 to 1,300 recognized animal families.
  • One family can encompass many species of animals. Families group together related genera (plural of genus), and each genus contains multiple species that share common characteristics.

For example:

  • Felidae (the cat family) includes various genera such as Panthera (which includes lions, tigers, leopards, and jaguars) and Felis (which includes domestic cats and wildcats). Each of these genera contains multiple species.
  • Canidae (the dog family) includes the genus Canis (which includes dogs, wolves, and coyotes) and other genera like Vulpes (foxes). Each genus within the Canidae family contains multiple species.

Once you have finished the model be sure to share the link in public.

Signup and get access to similar projects

We will use it to give you access to your account.
Already have an account? Login here.

Difficulty

  • intermediate

Average duration

1 hrs

Technologies

  • sql

  • postgres

  • database

  • modeling

Difficulty

  • intermediate

Average duration

1 hrs

Technologies

  • sql

  • postgres

  • database

  • modeling

Difficulty

  • intermediate

Average duration

1 hrs

Technologies

  • sql

  • postgres

  • database

  • modeling

Difficulty

  • intermediate

Average duration

1 hrs

Technologies

  • sql

  • postgres

  • database

  • modeling

Signup and get access to similar projects

We will use it to give you access to your account.
Already have an account? Login here.

Difficulty

  • intermediate

Average duration

1 hrs

Technologies

  • sql

  • postgres

  • database

  • modeling

Difficulty

  • intermediate

Average duration

1 hrs

Technologies

  • sql

  • postgres

  • database

  • modeling