Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone check if I did this correctly? I need help with the lines connecting the tables. A local pet store wants to track data
Can someone check if I did this correctly? I need help with the lines connecting the tables.
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 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. Step 2: Follow the same process as in ICA1 part 2: (1) Create a new model in MySQL Workbench. (2) Create a new Diagram. (3) Create tables for the Animal, Type, Disease, and Keeper. Create Primary keys in them (You don't need to define all the columns of these tables here in part B). Create the following connections and use MySQL Workbench tools to define their maximum and minimum cardinalities: - Animal - Type - Animal - Disease - Type - Type Keeper - Disease - Health KeeperStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started