$(\frac{n}{00})$

Database Management Systems

Project

In groups of $4$ students, select one of the following problem descriptions:

Problem $1$: The Riyadh National Zoo

The Riyadh National Zoo has many animals.

Every animal has a unique animal ID$,$ type, age, and gender.

Animals may have many diseases and the beginning and duration of a disease need to be recorded.

Each disease has a unique name and a set of symptoms.

An animal keeper takes care of one or more animals.

Every animal may have many keepers.

An animal keeper may or may not be familiar with many diseases.

Every disease must be handled by many animal keepers.

Animal keepers have a name, employee ID$,$ SSN$,$ address and phone number.

Every animal must be in a cage.

Every cage may have many animals.

A cage can be emptyCage or nonemptyCage but not both.

Every cage has a cage ID$,$ area and height.

Every nonemptyCage has a numberOfAnimals.

A cage keeper may take care of many non$-$empty cages.

Every non$-$empty cage must have many cage keepers.

Empty cages don't need any cage keepers.

Cage keepers have a name, employee ID$,$ SSN$,$ address and phone number.