Part $2.$ Specify the maximum and minimum cardinality based on the following statement. If either

maximum or minimum cardinality is not given, identify them based on your assumption. Follow the

same procedure as in Part $2$ of ICA$1$ and use the power point template to answer this question.

Scenario $3$: Local Pet Store

A local pet store wants to track data of the animals it sells. This involves keeping track of types of

animals and the keepers who work at the store. The company also wants to keep track of the disease

record of each animal.

The database should track animal's age, gender, and weight. $(1)$ Every animal in the store is part of one

type but there can be at least one or multiple animals in each type. Every type has a unique name,

category, and description.

$(2)$ Animals may be healthy or have one disease or more than one disease. There can be a disease that

no animal currently has. Also, there can be several animals that have the same disease. A disease has

a unique name and description. The beginning time and the duration of a disease of each animal also

need to be recorded.

All keepers have name, employee ID$,$ ssn$,$ address, role and phone number. A keeper is designated as a

type keeper or health keeper depending on its role. $(3)$ Although a type keeper takes care of only one

type of animals, each type may have at least one or many type keepers. $(4)$ A health keeper may

handle at least one or multiple diseases of animals, but each disease is taken care of by only one

health keeper.

Animal$-$Type

Animal$-$Disease

Type$-$Type Keeper

Disease$-$Health Keeper