Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The draft entities listed below are for a pet store that sells not only food, treats and toys but animals as well. Below is a

The draft entities listed below are for a pet store that sells not only food, treats and toys but animals as well. Below is a current draft of DOG, CAT, BIRD, RODENT. In attempting to optimize your design you decide that you need to make some improvements to your model. What suggestion do you have for this model?
\table[[RODENT],[\table[[RodentID: VARCHAR [PK]],[Breed: VARCHAR],[DOB: VARCHAR],[Color: VARCHAR],[LifeSpan: VARCHAR]]]]
The design is fine. No improvements need to be made.
Create a sub entity called ANIMAL with super types for DOG, CAT, RODENT and BIRD.
Create one entity called DOG_CAT to reduce the number of entities by one.
Place all common attributes in a super type called ANIMAL and create sub types for all the different animals.
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_2

Step: 3

blur-text-image_3

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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Shamkant B. Navathe

7th Edition Global Edition

1292097612, 978-1292097619

More Books

Students also viewed these Databases questions

Question

Show the properties and structure of allotropes of carbon.

Answered: 1 week ago