Create a data Entity Relationship Diagram based on the following business rules. You must

• Identify all of the main entities.
• Identify all of the relations and connectivities.
• Identify PK and FK
• Identify the type of participation optionality, existence dependency and relationship strength in all the relationships.
• Resolve the many to many relationships using the associative entities.

Jane Doe is a dog trainer. She would like you to design a database that would keep track of her customers and appointments. She needs to know the contact information for each dog owner, as well as key facts about each dog, including name, gender, breed, age, weight, vets name, whether the dog has been neutered, and optional comments such as will bite or likes bacon better than cheese. An owner may have more than one dog, of course.

Owners schedule appointments for Jane to come their homes or meet at a dog park for training. The appointments and fees are $35 for hour, and $50 for one hour. Thus, each entry in the schedule should show the length of the session, where it is located, with whom (owner and dog, in case they have more than one), the date, the starting time, and whether it is kept or cancelled. After each appt, Jane would like be able to make a few notes about the session.

Hint: You may consider an associative entity, APPOINTMENT.