Answered step by step
Verified Expert Solution
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?
tableRODENTtableRodentID: VARCHAR PKBreed: VARCHARDOB: VARCHARColor: VARCHARLifeSpan: 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 DOGCAT 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started