I need help with this ERD. WE are using Visio. Thanks!

A local kennel asked us to create a database to keep track of their puppies that they have for adoption. They are continuing to grow and have ran into problems with data management trying to use Excel spreadsheets to manage their information. They need to have ability to present reports to their customer showing puppies that are available for adoption and what tricks each puppy is able to perform. If a customer decides to adopt the puppy then they need to know which kennel the puppy is located at. Start with this report showing puppies, their kennels, and the tricks they have learned. REQUIREMENTS Your task is to create a normalized ERD using the information provided in the Kennel Report above. You need to identify the entities, attributes and relationships for the ERD. The ERD should be normalized to 3NF for the final solution. Use Visio to create your final ERD solution