Question
Creating a Data Model A veterinarian wants to hire you to design a database that enables the tracking of certain information. Specifically, she wants to
Creating a Data Model 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 pets name, breed, gender, and date ofbirth), owners (including each primary contacts first name, last name, cell phone number, and e-mail address), rooms (including each rooms number and description), and employees (including eachemployees 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 appointments reason, date, and start time). Create a data model/ER diagram that will serve 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. <-- This statement implies the type of relationship that exists between pet and room. 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. 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). Include foreign keys and primary keys.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started