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

Part 2. Specify the maximum and minimum

Part 2. Specify the maximum and minimum cardinality based on the following statement. If either maximum or minimum cardinality is not given, you will have to identify it. 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 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 multiple animals in each type. Every type has a unique name, category, and description. (2) Animals may have one or more than one disease. Also, there can be several animals that have a 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 many type keepers. (4) A health keeper may handle multiple diseases of animals, but each disease is taken care of by one and only one health keeper. 1) Animal-Type 2) Animal-Disease 3) Type-Type Keeper 4) Disease-Health Keeper

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 General Management Questions!