Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an enhanced ER model for the below problem. The American kennel association is trying to create a database of AKC registered dogs - prior

Draw an enhanced ER model for the below problem.
The American kennel association is trying to create a database of AKC registered dogs - prior to
their sale. They are preparing a prototype in Indiana. For each puppy, they want to retain the
puppys number (AKC registration code), and the puppys official name. They also need to know
if the puppy is show quality or pet quality. If 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
cant do any tricks, while others can do many tricks. Its also important to know when a puppy
learned a certain trick.
image text in transcribed

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

Big Data And Hadoop Fundamentals Tools And Techniques For Data Driven Success

Authors: Mayank Bhushan

2nd Edition

9355516665, 978-9355516664

Students also viewed these Databases questions

Question

=+what is the reason for this?

Answered: 1 week ago