Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please create an ERD 2. AKC Kennel Model The American kennel association is trying to create a database of AKC registered dogs - prior to

image text in transcribed

Please create an ERD

2. AKC Kennel Model The American kennel association is trying to create a database of AKC registered dogs - prior to their sale. They are preparing a prototype in Florida. For each puppy, they want to retain the puppy's number (AKC registration code), and the puppy's official name. They also need to know if the puppy is show quality or pet quality (these are the only characterizations and all puppies must fall into one of these groups). If a puppy is show quality, then they want to retain the date of last show and the place the puppy finished. If it is pet quality, they want to know the "defect" and if the puppy likes children. Each puppy lives in a kennel. Each kennel has a code, a name, and a location. Most kennels house quite a few puppies. The kennel association also wants to keep track of the tricks each dog can do. A trick can have an id code and a name. Some puppies can't do any tricks, while others can do many tricks. It's also important to know when a puppy learned a certain trick

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

Retailing Management

Authors: Michael Levy, Barton Weitz, Dhruv Grewal

9th Edition

0077512375, 9780077512378

More Books

Students also viewed these General Management questions

Question

Every non square system of linear equations has a unique solution.

Answered: 1 week ago