Question: 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.
 The draft entities listed below are for a pet store that

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!