Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design an ER (or EER) diagram based on the information given below. A local dog trainer holds obedience classes Champaign, Urbana, and Savoy. She teaches

Design an ER (or EER) diagram based on the information given below.

A local dog trainer holds obedience classes Champaign, Urbana, and Savoy. She teaches all five levels in each city. She teaches five levels of classesBasic, Intermediate, and three advanced level classes (I, II, and III) in each city.

Each class is associated with a class level. Owners cannot enroll their dogs in the Intermediate class unless they have taken the Basic class, and they cannot be enrolled in any of the advanced classes they have taken the Intermediate class. The class level includes the name, description, and the prerequisite of the class. The trainer will never take more than eight dogs in a single class, and she will not cancel a class unless no one signs up for it.

The dog trainer requires that the database keeps track of information about each dog, the dog's owner, and each class. Owner information includes the name, address (street, city, state, zip), phone, and email address. Dog information should include the dog's name, birthday, breed, color (can have more than one color), and the dog's shot date. Class information should include the class identifier, the city, start and end dates, start time, class size (number of dogs attended).

In addition, the trainer keeps track of the different skills that the dogs can perform after each class (such as fetch, rollover, heel, etc.). For each skill learned, the trainer records the name of the skill and assigns a grade (good, fair, or poor), along with a date. The trainer can teach the same skill, at increasingly levels of difficulty in a variety of the courses. For example, fetch can be taught in the basic, intermediate and any of the advanced courses. Some dogs would need to the beginners class multiple times before she was ready to move to the intermediate class. The dog trainer is very patient with such dogs (and owners) and allows the dog to repeat a course until the dog learns the skills (or the owner give up). For most dogs the grade assigned for each skill within a course would improve with each iteration.

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

Databases And Python Programming MySQL MongoDB OOP And Tkinter

Authors: R. PANNEERSELVAM

1st Edition

9357011331, 978-9357011334

More Books

Students also viewed these Databases questions

Question

When would you classify an investment as available-for-sale (AFS)?

Answered: 1 week ago

Question

What is job rotation ?

Answered: 1 week ago