Question
Create an ER diagram based on the following requirements. Show entities , relationships , and attributes and then convert that ER diagram into relational schema.
Create an ER diagram based on the following requirements. Show entities, relationships, and attributes and then convert that ER diagram into relational schema.
Pet-Health is a pet health care business that keeps track of:
For each employed veterinarian: vname, unique SSN, and a unique vid (veterinarians id).
For each client (pet owner): cname, a unique cid (clients id), and multiple phone numbers
For each pet patient: pname, ptype, and a unique pid (pets id)
For each employed vet-technician: vtechname, unique SSN, and a unique vtechid (vet technicians id).
Additional requirements:
Each veterinarian has at least one and up to 25 clients (owners) assigned to him/her Each client (owner) is assigned to exactly one veterinarian
Each pet belongs to exactly one client (owner) Clients (owners) can have many pets (Pet Health only keeps track of clients whose pets are treated by Pet Health)
Each veterinarian can work with up to 5 vet-technician but does not have to work with any Each vet-technician must work with at least two veterinarians but can work with up to 10 veterinarians
Pet Health keeps track of the date when a veterinarian started working with a particular vet-technician
A veterinarian does not have to mentor any veterinarians, but may mentor up to 3 other veterinarians A veterinarian is either mentored by one veterinarian or does not have a mentor
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