Include foreign keys and primary keys.

20OM + Assignment R2: Creating a Data Model in MS Visio (Part 2) Due date: Sunday October 7 by 11.59 PM A veterinarian wants to hire you to design a database that enables the tracking of certain information. Specifically, she wants to be able to track pets (including each pet's name, breed, gender, and date of birth), owners (including each primary contact's first name, last name, cell phone number, and e-mail address), rooms (including each room's number and descriptionl, and employees (including each employee's first name, last name, title, cell phone number, and e-mail address). In addition, and most importantly, your friend wants to track pet appointments (including each appointment's reason, date, and start time) Your job is to use MS Visio to create a data model/ER diagram that will sere as the blueprint for the database implementation. Hints Assume that the veterinarian is only interested in the primary contact for each pet. Of course an owner can have many pets, though. Every pet appointment involves one pet and one room.