uestion 3: ERD design Although you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining.that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, their names (which are unique), birthplaces, age, and style of training For each dog, the trainer, the year it was born, its unique name, the type of dog (e.g., Brittany, German Shepard, Collie, etc.), and its price must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels keep information about customers. For each customer, kennels keep that person's unique name, address, total amount of dollars spent at the kennel (very important!), and the trainers and groups (not types) of dogs that the customer tends to like 3.1) Draw the ER diagram for the database 3.2) Identify the relational schema for the database. Make sure to clearly indicate primary keys and foreign keys uestion 3: ERD design Although you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining.that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, their names (which are unique), birthplaces, age, and style of training For each dog, the trainer, the year it was born, its unique name, the type of dog (e.g., Brittany, German Shepard, Collie, etc.), and its price must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels keep information about customers. For each customer, kennels keep that person's unique name, address, total amount of dollars spent at the kennel (very important!), and the trainers and groups (not types) of dogs that the customer tends to like 3.1) Draw the ER diagram for the database 3.2) Identify the relational schema for the database. Make sure to clearly indicate primary keys and foreign keys