Hush Puppy Training, Inc. is a company that provides a training program for youn

Question

Hush Puppy Training, Inc. is a company that provides a training program for young puppies. Linus, the owner, just hired you to re-design their database system which currently contains one big table with the following fields.

Puppy ID, PuppyName, Kennel Code, Kennel Name, Kennel Location, Trick1_ID, Trick1_Name, Trick1_SkillLevel, Trick2_ID, Trick2_Name, Trick2_SkillLevel, .....Trick10_ID, Trick10_Name, and Trick10_SkillLevel.

The reason they need to re-design their database is that previously they thought that no puppy would ever be able to learn more than 10 tricks before graduation. Therefore, they only set up 10 groups of fields for the 10 tricks (coded as Trick1 through Trick10). But last week, a new puppy, Snoopy, just learned 25 tricks all within three weeks before his adoption by Mr. Charles Brown. Your job now is to apply the normalization rules to improve their database.

Explanation / Answer

Hi,

Puppy ID, PuppyName, Kennel Code, Kennel Name, Kennel Location, Trick1_ID, Trick1_Name, Trick1_SkillLevel, Trick2_ID, Trick2_Name, Trick2_SkillLevel, .....Trick10_ID, Trick10_Name, and Trick10_SkillLevel.

We are break into different tables

1. PuppyInfo(Puppy ID, PuppyName)
This table store information about Puppies.

2. KennelInfo(Kennel Code, Kennel Name, Kennel Location, Puppy ID)
This table store Kennel information about puppy.

3. TrickInfo(Trick_ID, Trick_Name, Trick_SkillLevel)
This table store trick information for puppies.

4. puppyLearn(learn_ID, Puppy ID, Trick_ID)
This table handle relation with no trick learn by puppies.

Let me know if change requied

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.