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 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 of ICA and use the power point template to answer this question.
Scenario : 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. 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.
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. Although a type keeper takes care of only one type of animals, each type may have at least one or many type keepers. A health keeper may handle at least one or multiple diseases of animas but each disease is taken care of by only one health keeper.
AnimalType
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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
