KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
If I have a class called animal, dog and fish is the subclass. The animal have attribute called "color". Dog have the attribute called "tail length", and the fish don't have this attribute. Fish have the attribute called "weight", the dog don't have this attribute. So, I want to design a database to store this information. What should I do? Here is some ideas: Idea 1: Making an animal table, and the table have type, to find what kind of animal, if it is a dog, just get the result from dog table. Animal: color:String type:int Type: Dog:0 Fish:1 Dog: TailLength:int Fish: Weight:int Idea 2: Store only Dog table and Fish table in the database, remove the animal table. Dog: Color: String TailLength: int Fish: Color: String Weight: int
Tags (comma-separated)
Save Edits
Cancel