I need help figuring out the relationship between these entities. What is 1 to many, 1 to 1, etc. Also, the bridge entities are confusing me and I'm not sure what the last bridge entity is. If someone could make a data model for this and help walk me through it, that'd be great.

Assignment #2: 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 (inclucing each room's number and description), 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 serve as the blueprint for the database implementation. 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. There are six entities altogether, including two bridge entities. (Hint: one of the bridge entities connects pet appointment and employee.) Remember that each entity name should be singular (e.g. "pet," not "Pets"). Please submit a PDF of your MS Visio file Assignment #2: 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 (inclucing each room's number and description), 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 serve as the blueprint for the database implementation. 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. There are six entities altogether, including two bridge entities. (Hint: one of the bridge entities connects pet appointment and employee.) Remember that each entity name should be singular (e.g. "pet," not "Pets"). Please submit a PDF of your MS Visio file