Question: Part 2 . Specify the maximum and minimum cardinality based on the following statement. If either maximum or minimum cardinality is not given, identify them

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 ICA1 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, ss, 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 anima|s, but each disease is taken care of by only one health keeper.
Animal-Type
Animal- Disease
Type - Type Keeper
Disease - Health Keeper
Can anybody tell me if my cardinalities are correct? If not please help me with finding the correct solution.
 Part 2. Specify the maximum and minimum cardinality based on the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!