Design one or more relational database models

[iFialAtFail]

Create one or more designs for the database data model (schema) that can be implemented in a later ticket. This design should come from the following requirements:

_Directory of Dog Breed Information

• All of the useful attributes relevant to dog owners and breeders, regarding each breed, should be included.

Initial attribute ideas are: Picture(s), Average Height and Weight, Life Expectancy, Temperament, Hair Shedding, Activity, Sociability, Intelligence, Child Friendly, Care Level, Health Problems, Genetic Profile (Inheritance) and Feeding Habits. We can clarify this before we do any modelling or introduce any database schema.

We can clarify the source of data for dog breeds at a later stage.

Health data: we should focus on genetically specific problems, where health screening information is a point, e.g. owner can showcase documents about issues, and that doggy is free of these issues. It is also an advantage if a dog has a pedigree.

The first and most important should be: try to imagine that you are a wannabe dog owner. You have no knowledge about dogs, how you need to manage their life, how your life will change if you become a dog owner, etc. That ‘s a cornerstone issue to avoid an inappropriate relation. Having a dog takes more than a decade in your life.

Relevant and useful data relationships
We should be able to query the database and return dog breeds based on factors such as: compatibility with other breeds, biological factors.
We can specify a model for filtering, ordering and we can relate dog breed model_