Your cart is currently empty!
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…
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 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.
Hints
o That is, a pet can have appointments in many rooms over time, and a room can be used (in an appointment) by many pets over time.
Please submit a PDF of your MS Visio file.