Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an ER diagram from MS Access based on the following requirements. Show entities , relationships , and attributes . Then convert into a relational

Create an ER diagram from MS Access based on the following requirements. Show entities, relationships, and attributes. Then convert into a relational schema. Show all tables, primary key, foreign key and referential integrity lines.

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Microsoft SQL Server 2012 Programming

Authors: Paul Atkinson, Robert Vieira

1st Edition

1118102282, 9781118102282

More Books

Students also viewed these Databases questions