Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

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 Keeper

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions